| Author |
Question about cursor as stored procedure parameter
|
Justin Chu
Ranch Hand
Joined: Apr 19, 2002
Posts: 209
|
|
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
|
 |
 |
|
|
subject: Question about cursor as stored procedure parameter
|
|
|