Function Returns a Recod Datatype

From: Mário Rui Romero <mariorui_at_binomio-msi.com>
Date: Fri, 06 Dec 2002 16:31:32 +0000
Message-ID: <ptj1vuoj9u9sjesoogqs7vb9peh6qfg1og@4ax.com>

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. Received on Fri Dec 06 2002 - 10:31:32 CST