Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Oracle 10g] Can't run SQL Scripts. Why?
> ORA-01400: cannot insert NULL into
> ("FLOWS_020100"."WWV_FLOW_SW_RESULTS"."FILE_ID")
Without having seen your script, it is obvious that you are inserting a
record in to the FLOWS_020100.WWV_FLOW_SW_RESULTS table. The FILE_ID
column has a NOT NULL constraint and you are attempting to insert a
record with NULL in that column.
You'll have to do some debugging of your script to find out why you are attempting to insert NULL into this column when that operation is not allowed.
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Fri May 05 2006 - 08:29:52 CDT
![]() |
![]() |