Re: No errors showed in the DBA Studio

[JOE TESTA]

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 >>> [EMAIL PROTECTED] 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 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 <[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).