Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [Oracle 10g] Can't run SQL Scripts. Why?

Re: [Oracle 10g] Can't run SQL Scripts. Why?

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Fri, 5 May 2006 13:29:52 GMT
Message-ID: <Iyso62.DA3@igsrsparc2.er.usgs.gov>


> 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" - Unknown
Received on Fri May 05 2006 - 08:29:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US