# Getting result from Oracle stored proc into dataset

**URL:** <https://forum.inductiveautomation.com/t/getting-result-from-oracle-stored-proc-into-dataset/68743>\
**Category:** Ignition\
**Tags:** scripting\
**Created:** [January 18, 2023, 5:29pm UTC](https://forum.inductiveautomation.com/t/getting-result-from-oracle-stored-proc-into-dataset/68743 "2023-01-18T17:29:29Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 18, 2023, 5:48pm UTC](https://forum.inductiveautomation.com/t/getting-result-from-oracle-stored-proc-into-dataset/68743/2 "2023-01-18T17:48:36Z")

</div>

Pretty sure you won't be able to do that. The Oracle JDBC examples require you to register the parameter as `oracle.jdbc.OracleTypes.CURSOR`, which is not available in Ignition. (Only generic JDBC types are supported in Ignition--the actual drivers are in isolated classloaders in order to make connection pooling transparent.)

You'll probably have to wrap that procedure with another that explicitly SELECTs from that cursor. (Looks complicated--wrapping in a TABLE() function somehow. I've not used Oracle in years....)

---

_[View the full topic](https://forum.inductiveautomation.com/t/getting-result-from-oracle-stored-proc-into-dataset/68743)._