Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> return single record

return single record

From: Shishir <shishir_at_agnisoft.com>
Date: Tue, 18 Dec 2001 05:09:30 -0800
Message-ID: <F001.003DED18.20011218042519@fatcity.com>

Hi Gurus!
 

i want to return a SQL which will call a function which returns one and only record.
like select   function(arguments list)
 from dual; (or something similar to that);
I am not supoosed to use ref cursor or object (collection type) or pl-sql   table
.
This funtion will certainly return use a user defined data type ( i am guessing ) but i want it to be used  in SQL statement.
thanx in advance..
 
 

Shishir Kumar MishraAgni Software (P)
Ltd.,Bangalore-560055, India
Email :shishir_at_agnisoft.com
 
 
Received on Tue Dec 18 2001 - 07:09:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US