I realize that this is not an Oracle support forum, but I am hoping someone has advice on how to do this...
We're migrating a series of stored procedures from MSSQL to Oracle per customer request. I've run into issues with the SELECT procs; specifically Ignition's DB engine doesn't seem to support the oracle cursor type, nor receiving a series of out params. Oracle doesn't appear to offer a standard dataset return
I have been able to execute stored procedures via scripting by defining OUT parameters.
I can run the contents of any stored procedure directly from Ignition's DB browser or a named query.
My ask: Is there any way to return an Ignition query-friendly dataset from an Oracle Stored Procedure? Or are they incompatible (as they appear thus far)?