Re: table functions from Discoverer or TOAD problem

Ecce Nihil wrote:

>I have a problem where I create a view over a table function and
>cannot see the data from TOAD or Discoverer, even though using SQLPlus
>shows the data OK.
>
>I create some types and a table function like so...
>
>create type query_t as object
>(
> user_name varchar2(30),
> sid number
>);
>/
>
>create type query_table as table of query_t;
>/
>
>create or replace
>function dwh_discoverer_queries return query_table pipelined as
>
> out_rec query_t;
>
>begin
>
> out_rec:=query_t('TEST',1);
> pipe row(out_rec);
> out_rec:=query_t('TEST',2);
> pipe row(out_rec);
>
> return;
>
>end;
>/
>
>And then create a view for this...
>
>create view vw_discoverer_queries as
>select * from table(cast(dwh_discoverer_queries as query_table));
>
>Selecting in SQLPlus gives me...
>14:55:08 SQL> select * from vw_discoverer_queries;
>
>USER_NAME SID
>------------------------------ ----------
>TEST 1
>TEST 2
>
>
>But when I look at TOAD or Discoverer I get the right number of rows
>and the column types are right but the columns are empty! Anyone seen
>this?
>
>thanks!
>
>

The versions of these products might be important. The versions you have may not support
the functionality.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)