File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Question about cursor as stored procedure parameter
 
Similar Threads
how to develop reports from a stored procedures
Registering IN OUT parameter
How to return a collection of records from a stored procedure?
SQLException Cursor Closed
Error :java.sql.SQLException: Invalid column index