923315 wrote:Please post to the correct forum
i have one issue in the loader in a unix script.
i am using sql loader which will insert more than 1000 record from a .txt file into a table.
but i want to add one functionality that if more than 500 hundred error occurs then the unix script will get aborted.
for example if first 10 record are inserted then for 501 error my script has to stopr executing and no data will be saved in the database.
means alredy inserted 10 rows will get deleted.
is this possible with sql loader?
i am thinking that i will first all the record get inserted into the table.
then i will read the .bad file
if the line is greater than 500 then i will apply the rollback statement.
pls let me kinow how to do?
many thanks in advance..