Two concurrent threads are executing an Proc/C++ program which insert data into Oracle 9.0
I always get this error of
ORA-12592 TNS bad packet when both of them are inserting into the database at the same time. One thread insets data into table1 and second thread into table 2 which has a refrential integrity constraint on table1.
Since the client program and database are on the same machine, I cannot understand why I should get a packet error.
Can someone tell me what the problem is and how to solve them....
Thanks for your reply.
But there is not deadlock at all.
Table1 is not depended on table2.
Table1's primary key is deviceid which is referenced by table2.
My script for creating the table is
create table tbDeviceDescription
txtDeviceID varchar(10) primary key,
txtDeviceType varchar(14) references tbDevice,
txtroomid varchar(10) references tbroom,