Hi Vaishali,

What does the error message indicate ?

The error message would be of this format :-
ORA-01400: cannot insert NULL into (<SCHEMA>.<TABLE>.<COLUMN>)

(1) Identify the Schema, Table and Column
(2) Try to output the inserted value just before the INSERT.
(3) Is it calling any other procedure wherein the error is
propogated ?
(4) Is the table being populated using a SELECT ... if so,
check all the returned rows for a NULL value in that column.

Regards,
Jayadas

-----Original Message-----
From: Vaishali Valand
[mailto:oracledba-ezmlmshield-x48948311.[Email address protected]
Sent: Tuesday, February 27, 2007 4:09 AM
To: LazyDBA Discussion
Subject: ORA-01400

Hello Experts

I'm getting Ora-01400 when i run a this particular procedure. When i
cross checked the values which are being inserted non of them in a null
value. I dont understand why im getting this error when im passing all
the values correctly.

Can someone help me out.

Thanks

Vaishali.

Oracle LazyDBA home page