-
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
-
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
-
thanks! it helps
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|