We are updating our database using flat files. SQL Loader loads
records in temp table from a flat file. Our shell script then calls a
stored procedure that reads the records in the temp table, validates
them and then updates another table with the data.
We encountered a peculiar problem in our production environment, where
a file was processed correctly upto storing in the temp table stage.
Then the log shows 'ORA-01756: quoted string not properly terminated'
error. After that all the changes got rolled back.
We processed the same file on our test environment which is an exact
replica of the production environment and the file was processed
successfully without any errors.
Any idea as to what must have caused the error.
Received on Tue Dec 16 2003 - 05:14:49 CST
