| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: No errors showed in the DBA Studio
I'm not morally opposed to GUI tools... and using them doesn't make you a bad DBA. But I really think that you (generic you) need to understand what the tool is doing, so that if you end up somewhere that doesn't have and won't buy the tool, you can still do your job.
>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: Re: No errors showed in the DBA Studio
>Date: Tue, 21 Aug 2001 08:01:20 -0800
>
>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).
><< beamar.vcf >>
-- 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 - 11:13:28 CDT
 |
 |