Re: ResultSet from Stored Procedure

From: Rene Nyffenegger <Rene.Nyffenegger_at_gmx.ch>
Date: 26 Jun 2002 00:54:48 -0700
Message-ID: <ce60f507.0206252354.7db0d476@posting.google.com>

> ops$tkyte_at_ORA817DEV.US.ORACLE.COM> create or replace function f return
> myTableType

[.....]

> ops$tkyte_at_ORA817DEV.US.ORACLE.COM> select * from table( cast( f() as myTableType
> ));

[.....]

Hello. I found it very interesting that it's possible to have a function return a table type and select * on that function's output. However, I don't know why there must be a cast from f() to myTableType. f() is already declared to return myTableType.

Can someone give me a hint?

Rene Received on Wed Jun 26 2002 - 02:54:48 CDT