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 Then do the following steps at SQL prompt.

SQL > show errors
(Then it will show where the error is i.e line no) then
type
SQL > line no (ex: if show error shows 6/21: ----error) SQL >6
it gives the message
hope this helps

-- 
	AMARENDRA B NETTEM
        PH.No. (312)945-2116
        HOMEPAGE:  http://www.iit.edu/~nettama
	E-MAIL  :  nettama_at_charlie.acc.iit.edu