return single record

[Shishir]

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 Mishra Agni Software (P) Ltd., Bangalore-560055, India Email :[EMAIL PROTECTED]