Re: insert table error

Posted by ErmanArslansOracleBlog on Sep 21, 2018; 2:27pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/insert-table-error-tp6769p6771.html

Fact1:

A transaction can contain multiple parallel DML statements that modily
different tables, but after a parallel DML statement modifies a table,
NO subsequent serial or Parallel statment (DML or QUERY) can access the
same table again in that transaction.

Fact2:

Each insert in SQL*plus is considered a transaction, while the whole
PL/SQL BLOCK is considered a transation.

Probably, these inserts are done in a PLSQL block.. (in that script, there is probably a PLSQL block and the inserts are coming from that block)

So, if it is a PLSQL block, then this error is normal.
In that PL/SQL Procedure, just insert a commit after the 1st DML statement prior to the 2nd DML statement (after 2nd tprioer 3rd and so on )on the same table in the same transaction.