Serge Rielau <srielau@ca.eye-be-em.com> wrote in message news:<c0b5u9$re1$1@hanover.torolab.ibm.com>...
> Is this a dynamic compound statement? Dynamic compound does not support
> cursors. Only FOR loop.
>
> Cheers
> Serge

Hello Serge,
I'm sorry, but I don't know what you mean by dynamic compound
statement.The same code works if I put it in a procedure. It this what
you mean by dynamic compound statement? What can't we use cursors out
of procedures. I have found that some things works in triggers but not
with procedures.

Thank you.