where to use ref cursor ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sanQUEST
    New Member
    • Aug 2008
    • 7

    where to use ref cursor ?

    hi,

    can anyone plz tell me where to use ref cursor ? I want some scenarios in this regard.I appreciate good comments.Thanks in advance.
    san
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    please check for some related articles in the howto section of oracle.

    Comment

    • AdusumalliGopikumar
      New Member
      • Aug 2007
      • 42

      #3
      Example

      I have procedure to which the user can pass emp id or name of the employee and the output of the procedure is the salary of the given input

      here there will be 2 different select statements one with empno in where clause and the other with name in where clause

      here i will use the same ref cursor for both the select statements and i can pass the ref cursor as output variable .

      Comment

      Working...