Re: ORA-01756: quoted string not properly terminated

"Arif" <khanbkup_at_yahoo.co.uk> wrote in message news:651adcd8.0312160314.38c54c8a_at_posting.google.com...
> 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.

You may need to post your control file and the line of data that was rejected Received on Tue Dec 16 2003 - 05:24:00 CST