Re: Need help creating PL/SQL stored procedure

In article <ac593.23.000F7D53_at_freenet.buffalo.edu> ac593_at_freenet.buffalo.edu writes:

> --sometimes, when i try to create a procedure or function, i get the message:
>
> Warning: Procedure created with compilation errors
>
> --unfortunately, the errors are not listed
>
> --it would be helpful to know which (if not all) lines of code actually caused
> the errors
>
> --is there a way to get more meaningful diagnostic messages when this happens?

After the CREATE PROCEDURE statement is issued and an error is returned, a SHOW ERRORS statement would return the compilation error(s).

Alternatively, you can query the data dictionary views <USER|ALL|DBA>_ERRORS to list errors using any tool or application.

This is documented in the Oracle7 Server Application Developer's Guide, page 7-14.

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Applications Engineer .................. 300 Oracle Parkway, Box 659306
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299