146
Views
3
Comments
How to use Ref Cursor output parameter in OutSystems Extension Method
Question

I have created an Extension to Call different DB procedure from an external oracle database. There are some procedures which return (Output parameter) Ref Cursor type.


I created output type as record list but in .Net code, i could not find any mapping data type for Oracle Ref Cursor.


Can any one provide any suggestion or sample code for it.

Rank: #432

Hi,

These components are old, but they might provide you an example how to call oracle procedures and assign them to a record list or the solution you need.

https://www.outsystems.com/forge/component-overview/891/oracle-connector-p9

https://www.outsystems.com/forge/component-overview/392/oracle-connector

Rank: #21411

Hi nelson,


I checked above links, P9 is new version of other one. Thus, both are same components.


I opened P9, its kind of extension which has two methods; one to call DB procedure and other for DB Function.


For DB procedure, it is giving parameter for Ref Cursor out put but as "Object" type. 


I am concerned that how that Object will be converted to a list of a specific Structure in OS server action. As I have closed timeline, so I might not be in position to do a POC with no output. I will try it later but if you have any idea about conversion in OS from object to List or any other resolution for subjected query, kindly let me know

Rank: #7564

It seems now still no solution to deal with the RefCursor datatype, right ?