This is because one or more of your character fields contains a null ('') [two single quotes] and if you want a blank field it has to contain a blank (' ') this has to do with the table being created with the NOT NULL specification for the field. To find the culprit (if it is a database column or variable loaded from a column) you have to display the value with something right before and right after it, I use the pipe (|) character. Other than displaying or showing the values for inspection, you would have to test them with an IF statement.
......Rob
----------------------------------------------------------------------------
Robert Goshko | Axis Developments | System Consulting Services
robert.goshko@axis-dev.com | Sherwood Park, AB | (403) 417-AXIS
-----Original Message-----
From: Chris Hagen [SMTP:Chris_Hagen@LASALLE.COM]
Sent: Monday, March 16, 1998 10:53 AM
To: Multiple recipients of list SQR-USERS
Subject: Insert Errors - Specific Fields
Hello.
I have a question concerning INSERT errors and debugging them.
Presently I am inserting values in an SQR to a table with over 100
fields. I am getting the following error.
__________________ERROR_________________________________________
SQL Status =-1400 SQL Error = ORA-01400: mandatory (NOT NULL) column
is missing or NULL during insert
__________________END OF ERROR__________________________________
Id there any way to determine what field is producing this error or
any other error that may occur in the future.
Thank you for your time and consideration.
Unrecognized Data: application/ms-tnef