Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How I can pass Cursor as In parameter

 
Pradeep Chaubey
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic