Sign in to follow this  

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

Recommended Posts

eliokh    3

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

Share this post


Link to post
Share on other sites
eliokh    3

any one?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.