SOS :: A strange case of ORA-01400: cannot insert NULL!!!

From: Dexter <dexter_at_rec-all.com>
Date: 22 May 2004 06:28:45 -0700
Message-ID: <607d10e1.0405220528.20528d38@posting.google.com>

Hi All,

I've recently moved from Oracle 8.1.7.4 to 9.2.0.2. i have started to see one of my Pro*C programs error out saying.

ERROR while bulk inserting into GRT_TXN for ID <1> KEY <83^2000^3^29> Error : <-1400> : <ORA-01400: cannot insert NULL into ("DEXTER"."GRT_TXN"."TRANS_ID") But the subsequent run of the same job inserts the records which errored out previously.

The table is a local table. and i'm not using DB links to access this table.

please let me know what could be the problems, also gimme some pointers where i can look for help.

Awaiting Help.
Dexter. Received on Sat May 22 2004 - 08:28:45 CDT