[Oracle Connector P9] How to match stored procedure with declared type output param (oracleconnector P9)?

Forge Component
(8)
Published on 2015-03-13 by Grazina
8 votes
Published on 2015-03-13 by Grazina

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?

Solution

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

Solution