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.
In SQL*Plus you can use:
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 of the object
Name of the object
Type of object
Sequence number, for ordering
Line number at which this error occurs
Position in the line at which this error occurs
Text of the error
ALL_ERRORS and DBA_ERRORS. Limit by NAME and OWNER to target the results.
Hope that helps,
Senior Oracle DBA
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 ?
Try 'show error package ' at the prompt.
Hope this helps,