How To Interpret Return Code In Dba_audit_object
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How To Interpret Return Code In Dba_audit_object

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159

    How To Interpret Return Code In Dba_audit_object

    AS PER MY UNDERSTANDING THE VALUE 0 IN RETURNCODE IS SUCCESS AND REST FAILURE.IS THERE ANY WAY TO FIND THE CAUSE OF THE FAILURE FROM THE RETURN CODE.I AUDITED A TABLE FOR A PARTICULAR USER AND I FOUND 0 IN RETURN CODE FOR SOME ROWS AND SOME NUMBER FOR REST.NOW THE CUSTOMER TELLING ME THAT HE MADE ALL SUCCESS UPDATION AND HE IS ASKING THE REASON FOR THE FAILURE.HOW CAN I FIGURE OUT THIS FROM DATABASE.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    return code from where?

    return code can be customized, I can make 0 failure if I wish
    neither 0 is succesful and rest is failure, it depends

  3. #3
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    Pando,
    Yes you can customize,I agree with you.The returncode from dba_audit_object.But how will i know what is the cause for failure.

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Oracle Server message code generated by the action. Some useful values:

    zero: the action succeeded

    2004: security violation
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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