Newsgroups: comp.databases.oracle.misc Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: [Oracle 10g] Can't run SQL Scripts. Why? In-Reply-To: <1146818594.714502.86800@j33g2000cwa.googlegroups.com> X-Nntp-Posting-Host: edc-cv-160-52.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1146818594.714502.86800@j33g2000cwa.googlegroups.com> Mime-Version: 1.0 Date: Fri, 5 May 2006 13:29:52 GMT Lines: 27 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:127149 > 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@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