Re: PL/SQL compilation

On Mon, 09 Sep 1996 13:06:04 -0400, Michael Abbey <cpb4c52_at_nortel.ca> wrote:

>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
>###################################################################

Actually, Oracle's Procedure Builder will catch some errors on the fly. But, as for robust, I think it still has a way to go. It is fairly useful though.

Jim Joslin Received on Tue Sep 10 1996 - 00:00:00 CEST