Calling Oracle's stored procedure and return output parameters as result set

Calling Oracle's stored procedure and return output parameters as result set

  
Hi,
 
We want to call ORACLE's stored procedure and use its output parameter values in OutSystems application. We are using below line of SQL statements to do so,
====================================================
/* %LogicalDatabase%=GetLogicalDatabase({POS_EMAIL_LOG}) */
DECLARE status NUMBER;
    email_sk NUMBER;
BEGIN
    SSBI_PRES.PROC_I_POS_EMAIL_LOG (@EmailFrom, @EmailTo, @EmailDateTime, @Subject, @OutsystemsEmailId, status, email_sk);
 
    DBMS_OUTPUT.PUT_LINE  ('STATUS:::>>>'||STATUS);
    DBMS_OUTPUT.PUT_LINE  ('UNIQUE EMAIL_SK:::>>>'||EMAIL_SK);
END;
====================================================
 
Above sql statement is working fine, but it won't return value as result set. We need a code which will return these variables as a result set.
 
For example, In SQL Server we can simply write as,
====================================================
SELECT @status, @sk_number;
====================================================
 
Thank you in anticipation.
 
Regards,
Sagar Nannaware
Hi Sagar,

You can use an advanced query for that or use the Oracle Connector component.

See this post to get more details about calling store procedures.

Hope that helps
Hi Nuno,

Thank you for your suggestion. 

There is no documentation provided for Oracle Connector component, also there is no sample project. It will be useful for me, if you provide any sample project using this component.

Regards,
Sagar Nannaware