Re: Insert Errors - Specific Fields

[Cathlin DeRosa <cathlin@ROCKETMAIL.COM>]

I usually 'show' or 'display' any variable that is
being inserted into a 'NOT NULL' field.  It's
tedious, but I can always spot the problem this way.

Good Luck






---Chris Hagen  wrote:
>
>      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.
>

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com