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