Re: PL/SQL compile errors

In article <1992Oct31.050402.3020_at_exu.ericsson.se> ebuhob_at_ebu.ericsson.se writes:
>Hi,
>
>Short question regarding stored procedures in ORACLE7:
>
> Is there *any* way to get a hint about *what* is wrong in a stored PROCEDURE,
> FUNCTION or PACKAGE when the compiler doesn't accept it?
>
> When I use CREATE PACKAGE xxx IS ..., the only feedback I get is
> "Warning: Package created with compilation errors.", and that isn't
> really helpful ;-)
>
>/Hans

In SQL*DBA, say "show errors" for the most recent compilation, or "show errors package <package_name>" or "show errors package body <package_body_ name>". It helps to set charwidth > 80, to see all the line. These are documented in Vol III of the Developer's Release DBA Guide.

--Tim (tssmith_at_netcom.com) Received on Sat Oct 31 1992 - 21:31:00 CET