DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to find out DML statement failure

  1. #1
    Join Date
    Aug 2006
    Posts
    2

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    put debug into your scripts

  3. #3
    Join Date
    Aug 2006
    Posts
    2
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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
  •  


Click Here to Expand Forum to Full Width