I need to execute the function that located on Oracle server, that returns a REF Cursor type.
I have a connection opened in ADO.Connection object.
How can I run the function and what declarations of variables for REF CURSOR should I declare (maybe Recordset or variant)? Give some example, please.
The function in oracle looks like this:
Function Foo(par_exr IN NUMBER)
IS c_LRs MyDEFINITIONS.ref_cur_LRs;
OPEN c_LRs FOR
FROM "SYSTEM"."LRs" s
WHERE s.EXR = par_exr
ORDER BY s.EXNAME;
The package declaration is :
TYPE ref_cur_LRs IS REF CURSOR;
FUNCTION Foo(par_exr IN NUMBER) RETURN