AnsweredAssumed Answered

Oracle Procedure Ref Cursor

Question asked by MarkRobinson8331 on Feb 19, 2013
Latest reply on Jan 12, 2017 by rmovilla154084

Hi,
 I am retreiving data from an Oracle Stored Procedure, could you please post a sample Oracle Stored Procedure that is compatible with the Boomi AtomSphere database profile ? My procedure is listed below and does not appear to be compatible with the Oracle Database Profile in Boomi:


create or replace 
PROCEDURE TEST_ACCOUNT
(
account_ref_cursor_o OUT sys_refcursor
)
IS
BEGIN
OPEN account_ref_cursor_o FOR
        SELECT column1, column2
          FROM ACCOUNT_DATA
         WHERE ROWNUM < 3
END TEST_ACCOUNT; 

Outcomes