Re: No compile error messages for invalid procedures or views in Enterprise manager

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 17 Mar 2003 02:48:00 -0800
Message-ID: <1e8276d6.0303170248.37606855@posting.google.com>

"Robert Langen" <robert.langen_at_t-online.de> wrote in message news:<b50rs3$1th$01$1_at_news.t-online.com>...
> For some reason SHOW ERROR doesn´t show the error messages, too. Probably it
> should show the same messages like the error window in Enterprise manager.
> But it´s possible to doubleclick on the result window to show the code line
> producing the error.
>
> "Rauf Sarwar" <rs_arwar_at_hotmail.com> schrieb im Newsbeitrag
> news:92eeeff0.0303072300.23de1937_at_posting.google.com...
> > I don't use OEM to create or deploy code but from sqlplus you can use
> > SHOW ERROR right after you deploy your code to view error stack.

I've encoutered the same problem some time before. I think this is the error in OEM. I think that OEM in general doesn't work very well, so I'm not using it.
If you try alter procedure xxx compile and get errors, then show errors should show you the error codes and lines. If this for some reason will fail, you can use select from all_errors view. Something like:

  1* select name, type, line, text from all_errors SQL> /
CHGDBTTIMEDEPACC PROCEDURE 4 PLS-00201: identifier 'AVAILABLE_BAL' must be declared CHGDBTTIMEDEPACC PROCEDURE 3 PL/SQL: SQL Statement ignored
CHGDBTTIMEDEPACC PROCEDURE 3 PLS-00341: declaration of cursor 'CUR_BDT_LOANACC' is incom CHGDBTTIMEDEPACC PROCEDURE 8 PL/SQL: Item ignored
CHGDBTTIMEDEPACC PROCEDURE 11 PLS-00302: component 'AVAILABLE_BAL' must be declared CHGDBTTIMEDEPACC PROCEDURE 11 PL/SQL: Item ignored
CHGDBTTIMEDEPACC PROCEDURE 20 PLS-00320: the declaration of the type of this expression i CHGDBTTIMEDEPACC PROCEDURE 20 PL/SQL: SQL Statement ignored
CHGDBTTIMEDEPACC PROCEDURE 29 PLS-00320: the declaration of the type of this expression i CHGDBTTIMEDEPACC PROCEDURE 29 PL/SQL: Statement ignored
CHGDBTTIMEDEPACC PROCEDURE 37 PLS-00320: the declaration of the type of this expression i CHGDBTTIMEDEPACC PROCEDURE 37 PL/SQL: Statement ignored
CHGDBTTIMEDEPACC PROCEDURE 45 PLS-00320: the declaration of the type of this expression i CHGDBTTIMEDEPACC PROCEDURE 45 PL/SQL: Statement ignored
CHGDBTTIMEDEPACC PROCEDURE 47 PLS-00320: the declaration of the type of this expression i CHGDBTTIMEDEPACC PROCEDURE 47 PL/SQL: Statement ignored
CHGDBTTIMEDEPACC PROCEDURE 49 PLS-00320: the declaration of the type of this expression i CHGDBTTIMEDEPACC PROCEDURE 49 PL/SQL: Statement ignored
CHGDBTTIMEDEPACC PROCEDURE 56 PLS-00417: unable to resolve "AVAILABLE_BAL" as a column CHGDBTTIMEDEPACC PROCEDURE 54 PL/SQL: SQL Statement ignored

RVITESTPINS                    PROCEDURE            51 PLS-00302:
component 'GEXC_NODBOWNER' must be declared
RVITESTPINS                    PROCEDURE            51 PL/SQL:
Statement ignored
TEST                           PACKAGE BODY         87 PLS-00306:
wrong number or types of arguments in call to 'REMOVEED
TEST                           PACKAGE BODY         87 PL/SQL:
Statement ignored
TEST                           PACKAGE BODY        258 PLS-00306:
wrong number or types of arguments in call to 'INT_AUTH
TEST                           PACKAGE BODY        258 PL/SQL:

Statement ignored

26 rows selected.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.

Received on Mon Mar 17 2003 - 04:48:00 CST