Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Question about cursor as stored procedure parameter

 
Justin Chu
Ranch Hand
Posts: 209
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I understand (1), but can someone explain the meaning of declaration (2)?


Ref cursors are used for returning record sets from a stored procedure.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic