Jump to content



Photo
jdbc java oracle pl/sql

  • Please log in to reply
2 replies to this topic

#1 eliokh

eliokh

    Neowinian

  • Joined: 01-July 10
  • Location: Lebanon
  • OS: Win7/XP

Posted 11 April 2013 - 08:51

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);


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

Thank you in advance for your responses.
Regards


#2 OP eliokh

eliokh

    Neowinian

  • Joined: 01-July 10
  • Location: Lebanon
  • OS: Win7/XP

Posted 11 April 2013 - 10:04

any one?

#3 Kami-

Kami-

    ♫ d(-_-)b ♫

  • Tech Issues Solved: 2
  • Joined: 28-July 08
  • Location: SandBox

Posted 11 April 2013 - 11:37

http://docs.oracle.c...ql.htm#CHDJIBBI

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