... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.oracle.server

Oracle Sysadmins question their careers

44,300 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 42,631 of 44,300

Mladen Gogala to Michel Cadot

Re: Returning a REF cursor

31 Jul 16 18:34:21

   From: gogala.mladen@gmail.com   

   On Sun, 31 Jul 2016 19:07:43 +0200, Michel Cadot wrote:   

   > No problem for me.   
   >   
   > Regards Michel   

   You have properly declared the v_data variable as SYS_REFCURSOR, and the   
   OP did not. Also, if the cursor needs to be returned, maybe a function   
   would be more appropriate than a procedure?   

   --   
   Mladen Gogala   
   The Oracle Whisperer   
   http://mgogala.byethost5.com   

   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]