Reference cursor in oracle

• • Reply

  15 years ago

  by udayasree

  udayasree

  , India

  Joined 15 years ago
  Hi,
  
  I have been using this discussion board for solving some of my technical problems.
  Now I have a show stopper in my code. Please help me out in this regard
  
  I have a stored function which returns a reference cursor.
  I have to use this in a pl/sql block to get the values from the reference cursor.
  
  In the pl/sql block, I have a weak cursor defined.
  How do i assign the values coming from function to this?
  
  or how can i get the values displayed from that ref cursor using dbms_output.put_line()
  
  TIA,
  Sree
  Report abuse
• • Reply

  15 years ago

  by sreedhars79

  sreedhar

  US, India

  Joined 15 years ago

  hi udayasree,
  

  
  this is sreedhar , ur old classmet from Lkg to 4th class at Balanandakendram,
  pls contact me,
  bye
  

  
  sreedhar
  e-id: [email protected]

  Report abuse
• • Reply

  15 years ago

  by sreedhars79

  sreedhar

  US, India

  Joined 15 years ago

  hi udayasree,
  

  
  this is sreedhar
  pls contact me,
  bye
  

  
  sreedhar
  e-id: [email protected]

  Report abuse