webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

How to use cursor in JDBC adapter stored procedure call

  • 1.  How to use cursor in JDBC adapter stored procedure call

    Posted Fri May 06, 2011 09:25 AM

    Hi,

    I am trying to create a JDBC adapter service which calls a stored procedure. the out parameter for the SP is a cursor.

    Please let me know how to reference this cursor in the adapter service.

    Please find the IN and OUT parameters for the SP.

    p_IA_CURSOR OUT OC_CURSOR_TYPE.OC_GENERIC_CURSOR,
    p_IA_DIVISION_ID IN NUMBER,
    p_IA_SOLDTOCUSTCODE IN CHAR,
    p_IA_LAST_FILE_DATE IN CHAR default null

    Regards,
    Karthik


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


Related Content