Re: procedures and packages in SQL*Plus
Date: 10 Jul 2008 13:57:44 -0800
[Quoted] Tim Slattery (Slattery_T_at_bls.gov) 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
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 _at_foobar show error prompt creating bazbar _at_bazbar show errorReceived on Thu Jul 10 2008 - 23:57:44 CEST