aspose file tools*
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
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
 
 
subject: How I can pass Cursor as In parameter