Re: No errors showed in the DBA Studio

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Tue, 21 Aug 2001 05:05:05 -0700
Message-ID: <F001.00372077.20010821050607@fatcity.com>

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 <beamar_at_cidaut.es>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: carmichr_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Aug 21 2001 - 07:05:05 CDT