how to use an object in a select statement?

From: André Rothe <andre.rothe_at_imise.uni-leipzig.de>
Date: Fri, 25 Jul 2003 12:10:06 +0200
Message-ID: <bfqvlm$l9a$1@news.uni-leipzig.de>

Hi,

I wrote a function in package which returns an object like the following:

create or replace type as object (
  id number,
  test number,
  adate date
);

The function works very well, but I cannot use the return value in a select statement.

I tried:

select pa.func().id from dual;

But it doesn't work. How can I write a select statement, which use the attributes of the object?
Can I use the return values without a temporary table in which I have to copy the values?

Thank you
Andre Received on Fri Jul 25 2003 - 05:10:06 CDT