This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Question about cursor as stored procedure 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 » Products » Oracle/OAS
Bookmark "Question about cursor as stored procedure parameter" Watch "Question about cursor as stored procedure parameter" New topic
Author

Question about cursor as stored procedure parameter

Justin Chu
Ranch Hand

Joined: Apr 19, 2002
Posts: 209
    
    1
I'm encountering similar code as this



I understand (1), but can someone explain the meaning of declaration (2)?

A procedure which uses the above as a parameter.

A few questions:
What does (3) mean?
Since the cursor is declared as a package public/global object, is it true that I cannot/should not concurrently run this procedure?
What is a better way to write this?
[ February 23, 2007: Message edited by: Chu Tan ]
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
I understand (1), but can someone explain the meaning of declaration (2)?


Ref cursors are used for returning record sets from a stored procedure.


Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Question about cursor as stored procedure parameter
 
Similar Threads
How to return a collection of records from a stored procedure?
how to develop reports from a stored procedures
SQLException Cursor Closed
Error :java.sql.SQLException: Invalid column index
Registering IN OUT parameter