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