Can not insert null field
54673Oct 6 2004 — edited Oct 12 2004Hi,
I'm trying to insert some records into a table with fields as NOT NULL. When I try to insert i get the following error "ORA-01400: can't insert NULL in...", i know that i'm not inserting any null record on this field. When i remove the constraint NOT NULL, the mapping run ok and the target table as no NULL values in the specified field, so what's happening.
To understand my problem, i have a JOIN expression and the cursor in PL/SQL for this join gives empty records for the specified field, but between this JOIN and the target table i have one EXPRESSION that removes all nulls, and the cursor in PL/SQL at this point gives no nulls.
As i said before the mapping inserts no NULLS when i remove the constraints!
Any help!?
Thanks,
Vitor