Re: Function Returns a Recod Datatype

"Mário Rui Romero" wrote:

> Hi,
>
> I have a suspiction i would like to confirmate:
>
> ORACLE doesn't support a SELECT statement that invokes a function
> returning a Record datatype.
>
> example:
>
> SELECT fc_01(parameter1).namecolumn FROM Dual;
>
> I get the message that FROM clause is not were it was supposed to be.
>
> My conclusion is that Functions returning these kind of datatypes are
> only usefull in other functions!!
>
> Is this correct!?
>
> Thank you all.
> MRR.
Correct. The goal can be accomplished but not in the way you are doing it.

Are you doing this in a procedure or in SQL*Plus at the command line?

Daniel Morgan Received on Fri Dec 06 2002 - 10:40:28 CST