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).
begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundaci�n CIDAUT;Departamento de Inform�tica adr:;;Parque Tecnol�gico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Inform�tica fn:Beatriz Mart�nez Jim�nez end:vcard
