Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: No compile error messages for invalid procedures or views in Enterprise manager

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

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 7 Mar 2003 23:00:57 -0800
Message-ID: <92eeeff0.0303072300.23de1937@posting.google.com>


"Robert Langen" <robert.langen_at_t-online.de> wrote in message news:<b4ba6q$ub5$04$1_at_news.t-online.com>...
> I´m using Oracle 9.0.1 server and client. I use the enterprise manager to
> create new procedures or views.
>
> If these are invalid because of any kind of syntax problem, there is the
> button Compile to view error messages. For some reason no message at all is
> displayed. I remember that it was possible to view error messages using
> Oracle 8.1 Client and the same Oracle 9 database.
>
> Can anybody help? Thanks, Robert

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.

Regards
/Rauf Sarwar Received on Sat Mar 08 2003 - 01:00:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US