Re: Can you use weak reference cursors in Oracle Reports?

Richard Kuhler wrote:

> I don't follow. If you're suggesting to assign the weak reference
> cursor to a strongly typed one then how do you do that ...
>
> declare
> type trec is record (dummy dual.dummy%type);
> type trc is ref cursor return trec;
> rc_weak sys_refcursor;
> rc trc;
> begin
> open rc_weak for 'select dummy from dual';
> rc := rc_weak;
> end;
>
> 20:16:25 > /
> declare type trec is record (dummy dual.dummy%type);
> *
> ERROR at line 1:
> ORA-06504: PL/SQL: Return types of Result Set variables or query do not
> match
> ORA-06512: at line 7
>
> Richard
>
> DA Morgan wrote:
> >
> > Richard Kuhler wrote:
> >
> > > We have some stored procedures that generate queries and open reference
> > > cursors for them. Because the queries use dynamic statements, they must
> > > be opened as weak reference cursors. I know reports can use a strongly
> > > typed reference cursor directly in the data model tool. Is there a way
> > > to use a weakly typed one?
> > >
> > > Thanks,
> > > Richard Kuhler
> >
> > Certainly by packaging the original procedure into another proc.
> >
> > Daniel Morgan

No. Been a bit distracted lately and didn't read as closely as I should. Sorry.

Though you could concatenate it but that is undoubtedly not what you want.

Daniel Morgan Received on Thu Mar 13 2003 - 07:46:17 CET