Workflow Soluiton

 View Only
Back to discussions
Expand all | Collapse all

Oracle Integration to Stored Proc with ref cursor help?

  • 1.  Oracle Integration to Stored Proc with ref cursor help?

    Posted Mar 09, 2010 12:17 PM
    I am trying to build an integration to Oracle for the below stored proc.  As you can see one of the outputs variables has a type of SYS_REFCURSOR, which is common in Oracle.  I do not have that type avaliable for a parameter when building my integration.  I have tried just using text, hoping it would convert but I get the wrong number or types of arguments in call error.  What do you guys use when integrating to Oracle stored procs?  Do you not use ref cursors?

    CREATE

     OR REPLACE PROCEDURE CWX.spLKUPClientMnemonic

    (

    p_clientlist

    OUT SYS_REFCURSOR

    )

     AS

    BEGIN

     

    OPEN p_clientlist FOR

     

     

    select '- Global -' AS Company, '- Global -' AS MNEMONIC FROM DUALunion

     

    END

    /

    select * from REM_COMPANY; spLKUPClientMnemonic;