refcursor for pipeline table function?

How can you declare a strict reference cursor for a pipeline table function based on objects?

For example ...

create or replace type tobj is object (num number, dt date);
/

create or replace type ttab is table of tobj;
/

create or replace package pkg_pipeline as

• this doesn't work

    type trefcur is ref cursor return tobj;

• neither does this

    type trefcur is ref cursor return ttab%rowtype;

• this gives an internal error

    cursor cur_dummy is
    select tobj(null, null)
    from dual;

    type trefcur is ref cursor return cur_dummy%rowtype;

    function f_pipeline

        return ttab
        pipelined;

    function f_get_refcursor 
        return trefcur;

end pkg_pipeline;
/

Note: we won't have any real table in the database with this structure (that's the whole point of the pipeline).

Thanks,
Richard Received on Mon Jun 09 2003 - 15:35:21 CDT