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

[Quoted] 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
Received on Thu Mar 13 2003 - 05:21:44 CET