Hello,I've run into some trouble when trying to use the oracleconnector P9 component.I'm trying to call a stored procedure which has an output parameter of a type declared inside the package.The package contains the following types:TYPE REC_QUEUE_TYPE IS RECORD(QUEUE_OWNER VARCHAR2(128),QUEUE_NAME VARCHAR2(128));TYPE LST_QUEUE_NAME_TYPE IS TABLE OF REC_QUEUE_TYPE;
The output of the procedure i'm calling is of the type LST_QUEUE_NAME_TYPE.
How should I define my output parameter to match the output of the procedure?
Hi Glenn!
I think that this component can't call a function or stored procedure with user's defined Oracle types.
We had the same necessity, so, we took a look at the code and realized that it's not possible; in our case we created a rest service to make the job (outside outsystems - you can do it with extensions in Integration Studio too), and called it through REST integration, on Outsystems side.
Regards,
Tiago