DSXchange

Hi ,

Im trying to insert records into a table1 and trying to delete the records from the source once it inserts into table1, in the same job.I was successful in it.But when I try to run this,it is generating the following message,
DSP.Close Error -100 in $DSP.Close.

The job doesnt perform the delete from the source once it inserts into table1 and the DBMS error was DBMS.CODE=ORA-01008

Could you any one throw their opinion to ged rid of this error.

Check with oerr ORA 1008 what this code is telling you. Learn about locking mechanisms; whether Oracle will permit you to delete the same records you are selecting. Does it seem plausible? Re-think your approach.