Null values to DB causes integrity error. (Pro *C)

From: Colgate-Palmolive <ksacher_at_worldnet.att.net>
Date: 1998/04/03
Message-ID: <6g1ola$t16@bgtnsc02.worldnet.att.net>#1/1

Hello All,

We are currently extracting data from a flat file to an Oracle 7 database. A record is read from the file, and the data is stored in several variables by field. (Using ProC V2)

A SELECT is performed.

If the record exists in the Oracle database, but needs to be updated an INSERT is performed. If one of the update fields is NULL, because there was no data in the
flat file, an error is returned that the update is causing a data integrity error.

The field being updated does not have any default criteria. The parameter NOT NULL is NOT defined for this field.

However it is possible to update this record by using SQL PLUS and the Select Into manually. SELECT ACCOUNT SET AMOUNT = ' ' WHERE ID = 100. or

SELECT ACCOUNT SET AMOUNT = NULL WHERE ID = 100. Any ideas?? Thanks! Received on Fri Apr 03 1998 - 00:00:00 CST