From JTESTA@longaberger.com Tue, 21 Aug 2001 08:44:28 -0700 From: "JOE TESTA" Date: Tue, 21 Aug 2001 08:44:28 -0700 Subject: Re: No errors showed in the DBA Studio Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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>    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 >    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 > >Reply-To: ORACLE-L@fatcity.com> >To: Multiple recipients of list ORACLE-L > >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@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@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).