home bbs files messages ]

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

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

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

   Message 1,457 of 2,288   
   Alexander Pino to All   
   How to return a record set from a PL/SQL   
   02 Jun 04 14:26:33   
   
   XPost: comp.database.oracle   
   From: Alexander.Pino@cea-int.com   
      
   Hi,   
      
   does anyone know if, and how, I can return a record (set) from a stored   
   procedure/function?   
      
   What does the function have to do?   
   well at this moment I'm porting our product's database based global registry   
   from SQL Server to Oracle10g (as it has to work on both). Now I have a   
   function called CreateKey, which like the name says creates a single key   
   entry in the global registry. Afterwards it has to return with the created   
   key (a single row) and it's newly generated globally unique identifier, but   
   if the key already existed it should return with the existing key   
   information.   
      
   Could someone please help me?   
      
   ps. I'm using Oracle10g.   
      
   Thanx,   
   Alexander   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

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


(c) 1994,  bbs@darkrealms.ca