procedures and packages in SQL*Plus
From: Tim Slattery <Slattery_T_at_bls.gov>
Date: Thu, 10 Jul 2008 16:17:48 -0400
Message-ID: <ncrc74ts3hbtnq8jdp6p8kus7eub3nsepn_at_4ax.com>
[Quoted] 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.
Date: Thu, 10 Jul 2008 16:17:48 -0400
Message-ID: <ncrc74ts3hbtnq8jdp6p8kus7eub3nsepn_at_4ax.com>
[Quoted] 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.
[Quoted] 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.
-- Tim Slattery Slattery_T_at_bls.gov http://members.cox.net/slatterytReceived on Thu Jul 10 2008 - 22:17:48 CEST