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

Thread: anywhere to get details of the error while compiling a package/body?

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    Hi,

    Does anyone know what should I do inorder to get a details of the error while I am compiling a package or body?

    thank-u in advance.

    rgds,
    ngwh

  2. #2
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175
    In SQL*Plus you can use:

    SQL>show errors

    or query

    USER_ERRORS describes all current errors on all views, procedures, functions, packages, and package bodies owned by the current user. This view does not display the OWNER column.

    Column Datatype NULL Description
    OWNER
    VARCHAR2(30)
    NOT NULL
    Owner of the object

    NAME
    VARCHAR2(30)
    NOT NULL
    Name of the object

    TYPE
    VARCHAR2(12)

    Type of object

    SEQUENCE
    NUMBER
    NOT NULL
    Sequence number, for ordering

    LINE
    NUMBER
    NOT NULL
    Line number at which this error occurs

    POSITION
    NUMBER
    NOT NULL
    Position in the line at which this error occurs

    TEXT
    VARCHAR2(4000)
    NOT NULL
    Text of the error

    ALL_ERRORS and DBA_ERRORS. Limit by NAME and OWNER to target the results.

    Hope that helps,



    --clio_usa
    Senior Oracle DBA


  3. #3
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    thanks! it helps

  4. #4
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    hi dio,

    I have tried on my DB...when i attempt to compile a package body it give me
    "Package altered with compilation error.." however,when i type "Show error" it
    displayed "No Errors" ....*confused*

    ..I am wondering why??
    can help ? anyone ?

    thanks
    ngwh

  5. #5
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    33
    Try 'show error package ' at the prompt.

    Hope this helps,
    Umesh Sharoff

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