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
Hmmm... let me have it clearly ...
1. You want to execute a function using SELECT
2. This function will return only one record.
3. This function will return a *user-defined-record*
Well, Oracle doesn't have a problem with 1 maybe 2 but it certainly does
have a problem with 3. SELECT can't
Hi Raj !
Actually I had similar problems some days back where i was supposed to
treturn recordset(more than one) . At that time i created object and
collection of object and then using cast operator and the operator i was
able to return recodset from function . I could have used that function
I think using 'the' on the collection would be my second choice after ref
cursor. Why does your client doesn't want to use ref cursor? I can't think
of anything else, as returning arbitrary data structure would be a problem
in select.
Raj
__