Here's a radical thought. You could actually go into sqlplus and do a select
from the dba_errors or user_errors view. I realize that this is will cause
many on this list to think of me as a dinosaur, ready to be relegated to the
old DBAs home, but come on, if you are going to call yourself a DBA you
should be able to look things up in the database WITHOUT a GUI tool.
I'll even be nice and give you the query:
log into sqlplus as the procedure owner
select * from user_errors order by line;
here's an example:
SQL> create procedure this_is_bad
2 as
3 select * from dual
4 end;
5
5
5 /
Warning: Procedure created with compilation errors.
SQL> select * from user_errors order by line;
NAME TYPE SEQUENCE LINE
POSITION
---------------------------------------- ------------ --------- ---------
---------
TEXT
---------------------------------------------------------------------------------------
THIS_IS_BAD PROCEDURE 1 3
3
PLS-00103: Encountered the symbol "SELECT" when expecting one of the
following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> cursor
form current external language
The symbol "begin" was substituted for "SELECT" to continue.
THIS_IS_BAD PROCEDURE 2 4
1
PLS-00103: Encountered the symbol "END" when expecting one of the following:
. , @ ; for <an identifier>
<a double-quoted delimited-identifier> group having intersect
minus order partition start subpartition union where connect
SAMPLE_
The symbol ";" was substituted for "END" to continue.
>From: Beatriz Mart�nez Jim�nez <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: No errors showed in the DBA Studio
>Date: Tue, 21 Aug 2001 01:21:37 -0800
>
>Hello list,
>Oracle 8.1.7. NT4.0
>I have created some procedures in the DBA Studio, and when I try to
>compile them I get that the procedure status is Invalid, but in the
>'show error' window there is no message. The window appears but it�s
>completely empty.
>Could somebody tell me what happens? Do i Have to configure anything to
>display this errors?
>A lot of thanks,
><< beamar.vcf >>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
