Re: database procedure compiling error

George Xu wrote:
>
> Hi,
>
> When creating database procedure, I had a compiling error. How do I
> know the reason? any tools??
> Thanks a lot?
>
> George at
> George_Xu_at_NT.COM

In our 7.1.6 database, for db stored procedures, packages, package bodies, you can query the USER_ERRORS or DBA_ERRORS views by object name. This will give you your errors. You can also view the source code for the same objects in the USER_SOURCE and DBA_SOURCE views.

A quick way in SQL*Plus just after compiling the object is to use the command:

"SHOW ERRORS owner.object_name object_type". Something like this anyway.

Tracie

-- 
*****************************************************
|   e-mail   mailto:tracie_at_aosi.com                 |
|   website  http://www.aosi.com/tracie             |
*****************************************************