Re: Dynamic PL/SQL -> REF CURSOR in a procedure

"Klaus Zeuch" <KZeuchnospam_at_hotmail.com> writes:

> In Oracle 8i it can be done (see
> http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.display?p_dispid=479021456587);
> in 7.3 I would guess that it's not possible.

    Oh, by the way, can I write something like:

     IF ...
        OPEN cursor FOR
           SELECT ...
           WHERE ...
     ELSIF ...
        OPEN cursor FOR
           SELECT ...
           WHERE ...
     ELSIF ...
        OPEN cursor FOR
           SELECT ...
           WHERE ...
     ELSIF ...
        OPEN cursor FOR
           SELECT ...
           WHERE ...
     END IF;

     where the only differences would be in the WHERE parts in a

    Thanks. Received on Wed Aug 16 2000 - 04:55:57 CEST