This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes How I can pass Cursor as In parameter Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How I can pass Cursor as In parameter" Watch "How I can pass Cursor as In parameter" New topic
Author

How I can pass Cursor as In parameter

Pradeep Chaubey
Greenhorn

Joined: Jun 15, 2009
Posts: 20
Hello Everyone,

I have a function which takes Cursor as IN Parameter... Please someone help me "How I can pass Cursor as In parameter"...
Whether it will take Array as inparameter or any otherthing

FUNCTION MSTFUPRF
(
pi_acnt_id IN ACCOUNTS.ACNT_ID%TYPE,  IN parameter of Number type, Pass ACNT_ID
pi_ugrp_id IN USAGE_GROUPS.UGRP_ID%TYPE, IN parameter of Number type, pass UGRP_ID
pi_uprf IN trc_uprf , IN parameter of REF CURSOR type, This ref cursor contains vprf_id and apv_upd_default_value columns in this order.
po_message_group_id OUT VARCHAR2 OUT parameter of VARCAHR2 type
) RETURN NUMBER ;



Please help to write the Java code..... I am stucked
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: How I can pass Cursor as In parameter
 
Similar Threads
Wrong no or type of argument in line 1, column 7
Closing cursor in a stored procedure when invoked from a callable statement
Invoking a Oracle Stored Proc which takes a REF CURSOR as a IN parameter
how to return ref cursor arrays from stored procedure?
implementing stored procedure in hibernate