Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Bulk Binds and Dynamic Cursors
I've written a couple of PL/SQL procedures. The first accepts a parameter, of a partition name, which is used as part of a dynamic cursor. The second does the same basic work, but has the partition name hard coded, and makes use of bulk collects and forall processing. I've tried writing one that brings the 2 together but it fails with a message about an invalid cursor.
Is it possible to use bulk collects, with a dynamic cursor, or are the 2 incompatible? Received on Tue Jun 05 2001 - 14:25:38 CDT