-
How to find out DML statement failure
Hi,
I have been using pl/sql scripts for some DML operations (insert,update and delete) worked fine but all of sudden
the same scripts DML statements didn't work, when i checked
spool file of my scripts i can see only my message with 0 rows
updated or inserted without any ORA-xx errors.
Spool file message:
"No of rows updated: 0 " (no.of rows captured by sql%rowcount)
"No of rows inserted: 0 " (no.of rows captured by sql%rowcount)
But again when I re-run them it was normal, it could update/insert properly
"No of rows updated: 10 " (no.of rows captured by sql%rowcount)
"No of rows inserted: 100 " (no.of rows captured by sql%rowcount)
Can anybody suggest what went wrong or share similar problem solution.
rgds &t thx
krishv
-
put debug into your scripts
-
hi dave,
thx for your advise, i did put but nothing is traceable.I want to simulate the error but some how not happening.
rgds, krishv
-
everything is traceabke - you need to debug it yourself
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|