SQL & PL/SQL

Hi,

I am very new to Oracle and I desperately need help on this problem.

I have 4 Tables.

Table( id1_FK, id2_FK, id3_FK)
Table_1 ( id1_PK)
Table_2 (id2_PK)
Table_3 (id3_PK)

The return key (id1_PK) from insert into Table_1, return key (id2_PK) from Insert into Table_2 and return key (id3_PK) from Insert into Table_3 are all passed into
Table to be insert into Oracle.

But it seems like my Table_1, Table_2 and Table_3 data are not inserted into Oracle. I am using VB.NET to do my database insert. I heard from my colleague that the data will only be inserted after the whole .NET framework finished execution. But I already have problem insert into Table due to those primary keys and referential keys. So my Table_1, Table_2, and Table_3 is not insert into the Oracle.

Can someone advise me on this problem? or maybe those keys related to database?

Thank you so much. Appreciate any help given!