Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Unanswered: Error details from DBA tables

    Hi ,

    This is my first post in dbforums. I am new professional who just started working in Oracle.

    I am planning to collect the errors encountered during the execution of Procedure from Oracle DBA tables.

    Could you guys please help me by providing details of important DBA tables(or views) and the details they contain.(for eg dba_dependencies will contain details of other tables referenced,all_tables list all tables available in the schema).

    My need is to get error details encountered during the execution of stored procedures.


    Thanks for your time. Hopes someone can help me out.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    select table_name from dba_tables where table_name like 'dba%';
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by deepu2543651 View Post
    Hi ,

    This is my first post in dbforums. I am new professional who just started working in Oracle.

    I am planning to collect the errors encountered during the execution of Procedure from Oracle DBA tables.

    Could you guys please help me by providing details of important DBA tables(or views) and the details they contain.(for eg dba_dependencies will contain details of other tables referenced,all_tables list all tables available in the schema).

    My need is to get error details encountered during the execution of stored procedures.


    Thanks for your time. Hopes someone can help me out.
    You could find all "SYS" table/view definitions if you would take time to Read The Fine Manual(s), specially:
    Oracle® Database Reference
    and
    Oracle® Database PL/SQL Packages and Types Reference

    HINT: To get error details, lookup DBMS_UTILITY.FORMAT_ERROR_BACKTRACE
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Nov 2013
    Posts
    2

    Thanks a lot

    Thanks a lot for your helping hands .
    I got the required information from 'dba_errors' view.

    Thanks,
    Deepu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •