[JAVA] Passing pl/sql REF CURSOR -TO- a PLSQL STORED PROCEDURE using JDBC

[eliokh]

Dear All,

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.

Example:

  Type TC_grpheader Is Ref Cursor Return grpheader_record_type;

  Procedure set_grpheader (p_i_grpheader In   TC_grpheader);
[/CODE]

I need to call set_grpheader from JAVA. IS IT FEASIBLE????

Thank you in advance for your responses.

Regards

[eliokh]

any one?

[Kami-]

http://docs.oracle.com/cd/E11882_01/appdev.112/e10767/procedures_plsql.htm#CHDJIBBI

Figured you could do with a more in-depth overview about what a REF CURSOR is...