Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> return single record
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
![]() |
![]() |