It's not a secret anymore!*
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 Android Security Essentials Live Lessons this week in the Android 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

How I can pass Cursor as In parameter

Pradeep Chaubey

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

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

Please help to write the Java code..... I am stucked
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