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 -> discrete transactions

discrete transactions

From: Iain Wiseman <bibble_at_attglobal.net>
Date: Tue, 17 Apr 2001 09:23:49 +1200
Message-ID: <3adb62b4_4@news1.prserv.net>

I currently insert 600 records at a time in PROC using structures. I have two questions

  1. a) Can I use discrete transactions
  2. Is the only way to do this, start a PL/SQL block
  3. Will using discrete transactions could improve performance.

Thanks in advance.

Iain Received on Mon Apr 16 2001 - 16:23:49 CDT

Original text of this message

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