Oracle 01400 Error
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB ora-01400 cannot insert null into primary key Don Burleson Blog
cannot insert null into oracle ORA-01400: cannot insert NULL Oracle Database Tips by Burleson Consulting February 27, 2015 Question: I am tryingOra 01400 Cannot Insert Null In Oracle Forms
to insert null value in numeric data type and I got an ORA-01400 error? Here is the insertion statement: INSERT INTO INVOICE (ITEM_NUM, ITEM_DESC, DEL_QTY, SO_QTY, DATE_PURCHASE, RETAIL_PRICE, DISCOUNT, CUSTOMER_NUM)
Ora-01400 Cannot Insert Null Into During Import
You have 8 columns to inxert: VALUES ( '69112-95B', 'HORN KIT, CHROM', 1, NULL, 'OCT-11-03', 79.95, 15.99, 30086); Answer: Oracle oerr has this information on the ORA-01400 error: ORA-01400: cannot insert NULL into (string) Cause: An attempt was made to insert a NULL into the column "USER"."TABLE"."COLUMN". For example, if you enter:connect scott/tiger create table a (a1 number not null); insert ora-01400 error in informatica into a values (null); Oracle returns:ORA-01400 cannot insert NULL into ("SCOTT"."A"."A1") : which means you cannot insert NULL into "SCOTT"."A"."A1".Action: Retry the operation with a value other than NULL To see if a table allows NULL values, use tthe SQL*Plus desc command on the table name: SQL> desc invoice Another solution for the ORA-01400 error is to modify the table to make the column NULLABLE (i.e. allow a NULL value. See my notes on how tp make a Oracle table column nullable Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not
Ora-01400 Trigger
work correctly without it enabled. Please turn JavaScript back ora 01400 exception on and reload this page. Please enter a title. You can not post a ora-01400 exception name blank message. Please type your message and try again. More discussions in Retail Data Model All PlacesBusiness IntelligenceData WarehousingRetail Data Model This http://www.dba-oracle.com/t_ora_01400_cannot_insert_null.htm discussion is archived 6 Replies Latest reply on Aug 27, 2014 5:16 AM by Prabhakar2991 Error text: ORA-01400: cannot insert NULL into ("RMS"."ITEM_MASTER"."DEPT") Prabhakar2991 May 19, 2014 1:03 PM Hi All,I am Installing Retail Merchandising System(RMS) as part of Oracle Retail Application14.0. While installing RMS 14.0 https://community.oracle.com/thread/3561654 it's throwing error . I mean while running run_rmsdemodata.sql , it's throwing error like :=============================================================================================================================================Input truncated to 7499 charactersold 323: v_num_items := &num_items;new 323: v_num_items := 500;old 324: v_tran_level := &tran_level;new 324: v_tran_level := 3;Created the following items:Error Code: -1400Error text: ORA-01400: cannot insert NULL into ("RMS"."ITEM_MASTER"."DEPT")'Starting File: populate_rpm_dept_aggregration.sql'Inserting records into rpm_dept_aggregation for departments not yet present in the table'Starting File: populate_rpm_futureretail.sql''Execution of Demo Data script has completed.''Please check RmsDemoData.log for any errors.'=============================================================================================================================I have checked log file and found that populate_item_data.sql is trying to insert record into ITEM_MASTER. It is using DEPT column from DEPS table that is blank. Here I tried to find the script which loads data into DEPS table but I didn't get. Please suggest me what to do , I am stuck here. Operating System : RHEL 6.2 (x86-64)RMS Ver
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta http://stackoverflow.com/questions/16229004/oracle-cannot-insert-a-null-value-to-a-non-primary-key Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us http://www.novell.com/support/kb/doc.php?id=3758562 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, cannot insert helping each other. Join them; it only takes a minute: Sign up ORACLE - Cannot insert a NULL value to a NON-Primary Key up vote 1 down vote favorite I Have searched the web and various forums but I cannot figure out why this won't work. My Database is made up from the following Tables: CREATE TABLE cannot insert null CUSTOMER( custid Number(4), cfirstname varchar2(30), csurname varchar2(20) NOT NULL, billingaddr varchar2(30), cgender varchar2(1), CONSTRAINT custpk PRIMARY KEY (custid), CONSTRAINT genderconst CHECK(cgender in ('M','F','m','f')) ); CREATE TABLE PRODUCT( prodid Number(4), prodname varchar2(30), currentprice Number(6,2), CONSTRAINT cprice_chk CHECK(currentprice >= 0 AND currentprice <=5000 ), CONSTRAINT prodpk PRIMARY KEY (prodid), CONSTRAINT pricepos CHECK((currentprice >= 0)) ); CREATE TABLE SALESPERSON( spid Number(4), spfirstname varchar2(30), spsurname varchar2(30), spgender varchar2(1), CONSTRAINT salespk PRIMARY KEY (spid) ); CREATE TABLE SHOPORDER( ordid Number(4), deliveryaddress varchar2(30), custid Number(4) NOT NULL, spid Number(4) NOT NULL, CONSTRAINT orderpk PRIMARY KEY (ordid), CONSTRAINT orderfk1 FOREIGN KEY (custid) REFERENCES CUSTOMER(custid), CONSTRAINT orderfk2 FOREIGN KEY (spid) REFERENCES SALESPERSON(spid) ); CREATE TABLE ORDERLINE( qtysold Number(4), qtydelivered Number(4), saleprice Number (6,2), ordid Number(4) NOT NULL, prodid Number(4) NOT NULL, CONSTRAINT qty_chk CHECK (qtydelivered >= 0 AND qtydelivered <=99), CONSTRAINT price_chk CHECK(saleprice >= 0 AND saleprice <=5000 ), CONSTRAINT linefk1 FOREIGN KEY (ordid) REFERENCES SHOPORDER(ordid), CONSTRAINT linefk2 FOREIGN KEY (prodid) REFERENCES PRODUCT(prodid) ); And I am using an insert statement to insert the following: INSERT INTO
Favorite Rating: Error message creating database on an Oracle server "ORA- 01400: cannot insert NULL into "This document (3758562) is provided subject to the disclaimer at the end of this document. Environment Novell ZENworks 7.5 Asset Management - ZAM7.5Novell ZENworks 7 Asset Management - ZAM7 Situation The error at the end of the setup being:DBSetupScript Execution error:"C:\Program Files\Novell\ZENworks\Assetm~1\SQL\Oracle8\CSchema.log"The error section in the file shows:*ERROR at line 1:ORA- 01400: cannot insert NULL into("NCSYSTEM"."NC_WKSTNRECONCILEDATA"."RECONCILEDATA")ORA- 06512: at"NCSYSTEM.TSC_ADD_RECONCILE_DATA", line 17ORA- 06512: at line 1The setup then closes and never completes successfully. Resolution This and other similar errors can arise if using UTF-8 or AL16UTF16 character set. It is recommended to change the character set to WE8MSWIN1252. DisclaimerThis Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND. Document ID:3758562Creation Date:11-JAN-07Modified Date:27-APR-12NovellZENworks Asset Management Did this document solve your problem? Provide Feedback © Micro Focus Careers Legal close Feedback Print Full Simple Request a Call Follow Us Facebook YouTube Twitter LinkedIn Newsletter Subscription RSS