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.
Insert
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.