[itlabmh]

Hello,

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
AK

[aarroyob]

Have the fk an index created on it? Sure not.

The error probably is you have not desiggned correctly the application, so a deadlock take place and one of the two sessions is killed.

Cheers

[itlabmh]

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,
txtDeviceName varchar(100),
txtDeviceLocation varchar(100),
txtroomid varchar(10) references tbroom,
numPositionX number,
numPositionY number,
numPositionZ number,
numPositionH number,
numPositionP number,
numPositionR number
);

create table tbTransLoad
(
numTransID int primary key,
txtDeviceID varchar(10) references tbDeviceDescription,
txtStatus varchar(21),
txtPropertyValue int,
dtTransDateTime date,
txtCommandSource varchar(30)
);

And insert is done in the usual Proc/C++ Exec SQl insert.....
I am not able to see any problems anywhere.....
Thanks....