I have done several examples from which i call a PLSQL stored procedure using JDBC and get its returned Cursor and cast it to a ResultSet and read its data.
Now i need to do the opposite, I need to pass to a PLSQL stored procedure a REF CURSOR as an input parameter (from java jdbc) and let the PLSQL procedure handle the REF CURSOR (so passed from JAVA) in the stored procedure.
Type TC_grpheader Is Ref Cursor Return grpheader_record_type; Procedure set_grpheader (p_i_grpheader In TC_grpheader);
I need to call set_grpheader from JAVA. IS IT FEASIBLE????
Thank you in advance for your responses.