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

Home -> Community -> Usenet -> c.d.o.server -> Using BULK BIND.....

Using BULK BIND.....

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 23 Feb 2006 02:52:22 -0800
Message-ID: <1140691942.679454.27390@z14g2000cwz.googlegroups.com>


Hi,

Have a program which is currently processing a cursor and doing various bits and bobs with the data. Am making a change in which i need to insert data into a table for each row processed.

My question is would it be better to store this info in a PLSQL table first then once the cursor has completed use a BULK BIND to insert the data into the database table in one go rather than doing an insert on each iteration of the loop.

Using Oracle 9.2 and will be several thousand rows.

Thanks Received on Thu Feb 23 2006 - 04:52:22 CST

Original text of this message

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