Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Lock on a table and SQL*Net more data from client

2985497Jul 7 2015 — edited Jul 7 2015

Hi,

I have a problem loading data via Php into Oracle: the Php web page open an xml file, create a .csv and then Oracle starts using an external table to process data.

The problem is that, the second time Php tries to execute the following query:

INSERT INTO table1 T (field1, field2, field3, field4, field5, field6) VALUES ('aaa1E63819707', SYSDATE, 'KO', 'error', 'L', 'file_name.xml') RETURNING field1 INTO :id

on Oracle sessions I have a Row Exclusive lock on table1 and the wait SQL*Net more data from client.

Where is the problem?!?

Thanks,

Igor

This post has been answered by 2985497 on Jul 7 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2015

Added on Jul 7 2015

#general-database-discussions

5 comments

437 views