Re: PL/SQL compilation

Marco Savini wrote:
>
> Hi
> I'm new to PL/SQL and simply wanted to create some
> simple procedures in a package. As we work with the
> Server Manager I have no direct access to the procedure
> builder from Oracle. If I try now to create a package with
> CREATE PACKAGE xyz ...
> the SQL*Plus interpreter (or whatever) only tells
> me if everything was ok or not. A compilation error
> looks simply like this:
>
> MGR-00072: Warning: PACKAGE BODY xyz created with compilation errors.
>
> Well, you can imagine that this isn't very helpful for
> a beginner. Is there a way to let the package compile
> with some meaningful error messages? I need the answer
> as fast as possible, otherwise I'll have to get a look
> at the procedure builder (which would mean to move to
> our workstations :-(
>
> I hope you understand the question.
>
> Marco Savini
> savim_at_info.isbiel.ch

Unfortunately Marco, there is no robust application development environment for PL/SQL. Whenever you get the compilation error message text from Oracle issue the command "sho errors" which displays the contents of a table called user_errors. The error messages will be listed by line and coulmn number. Pretty?? No! Works? Yes!

Michael

-- 

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
###################################################################