Re: No errors showed in the DBA Studio

A lot of thanks Rachel,
it helps me a lot, although I would prefer to use a GUI tool (despite of looking like a
bad DBA).
Thank you,

Rachel Carmichael wrote:

> 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 - 10:58:15 CDT