RE: return single record

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 18 Dec 2001 05:28:50 -0800
Message-ID: <F001.003DED56.20011218051519@fatcity.com>

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 handle data structures it doesn't know about.

Call me old timer, but what stops you from using the "simple" way ... why SQL? my_rec := my_users_function(arglist);

You could do this dynamically too ...

Okay ... what am I missing in this picture?

Raj

---

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Tuesday, December 18, 2001 7:25 AM To: Multiple recipients of list ORACLE-L

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 :shishir_at_agnisoft.com  

*********************************************************************1

This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.

*********************************************************************1
Received on Tue Dec 18 2001 - 07:28:50 CST