Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Bulk Binds and Dynamic Cursors

Bulk Binds and Dynamic Cursors

From: Peter L <news_at_abc.co.uk>
Date: Tue, 05 Jun 2001 19:25:38 GMT
Message-ID: <3b1d313c.7120631@news.freeserve.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US