Yea but what happens when you need to perform something that you dont have
a gui tool for?
then you really will look like a BAD(and no not bad slang as in good)
DBA.
joe>>> beamar_at_cidaut.es 08/21/01 12:01PM >>>A
lot of thanks Rachel,it helps me a lot, although I would prefer to use a GUI
tool (despite of looking like abad 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 <A
href="
http://explorer.msn.com/intl.asp">
http://explorer.msn.com/intl.asp>>
--> Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
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:44:28 CDT
