Re: REF CURSORS and DYNAMIC SQL

Hi Phil,

I'm not sure i understand exaclty what you mean but I used ref cursor with fixed
statements in the following way:

type a ref cursor;
b a;

if xxxx then

   open b for
    select yyyy
   .....
else

   open b for
   select zzzz
end if
loop

   fetch b
end loop

Hope this helps.

Jeroen

Phil Spencer wrote:

> Does anyone know a way to bind a REF cursor created by a Dynamic SQL
> statement in ORACLE 7.3
>
> TIA
>
> Phil
Received on Fri Aug 07 1998 - 07:26:48 CDT