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,465 of 2,288   
   Alexander Pino to Alexander Pino   
   Re: How to return a record set from a PL   
   03 Jun 04 13:03:22   
   
   XPost: comp.database.oracle   
   From: Alexander.Pino@cea-int.com   
      
   Probably I should have mentioned that I want to use it in combination with   
   .NET and C# in particularly.   
      
   Alexander   
      
   "Alexander Pino"  wrote in message   
   news:40bdc779$0$49150$e4fe514c@news.xs4all.nl...   
   > 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