Re: procedures and packages in SQL*Plus

From: Malcolm Dew-Jones <>
Date: 10 Jul 2008 13:57:44 -0800
Message-ID: <487677c8$>

[Quoted] Tim Slattery ( wrote:
: I can enter stored procedures/functions and packages in SQL*Plus,
: that works fine. Except when there's a syntax error someplace. Then it
: tells me something like "Warning: Package Body created with
: compilation errors." But it doesn't tell me WHAT the errors are! It
: doesn't work that way with an anonymous PL/SQL block, that gives a
: fine syntax error report.

: Is there something I can set to get it to tell me what it objects to?
: I scanned the list of SET options, tried autotrace and flagger, still
: lost.

sql> show errors

If there aren't any errors then it says "No errors.", and it's cleared after each successful code creation, so it's useful to to simply call it every time.

	prompt creating foobar
	show error

	prompt creating bazbar
	show error
Received on Thu Jul 10 2008 - 23:57:44 CEST

Original text of this message