Re: Help a newbie trying to learn PL/SQL - No trace is showing up

"tk" <theronk_at_charter.net> wrote in message news:<vj0ovj57um481b_at_corp.supernews.com>...
> > The book is out of date.
> > From SQL*PLUS do:
> > SQL> @rdbms/admin/tracetab.sql
>
> Thank you so much for telling me that. I thought I was doing something
> wrong!!!
>
> > PLEASE try to UNDERSTAND the contents of the trace file!
> > With 9i the results are placed inside the DB & NOT in a trace file.
>
> Oh I understand basically what it's saying. I'm a long time systems
> programmer in C/C++/Java and have had to go thru many a stack trace/dump.
> The oracle one is no different. I was just scratching my head when the
> contents of the file did not agree with what the book said.
> -------------
>
> By the way, I tried running the @rdbms/admin/tracetab.sql and got a not
> found error... The output follows (I'm not sure what I'm doing wrong)
>
>
> SQL> ALTER SESSION SET EVENTS '10938 trace name context level 5';
>
> Session altered.
>
> SQL>
> SQL> -- Anonymous block which raises some exceptions.
> SQL> BEGIN
> 2 CallRaise(1001);
> 3 RaiseIt(-1);
> 4 END;
> 5 /
> BEGIN
> *
> ERROR at line 1:
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "TKOUSEK.RAISEIT", line 7
> ORA-06512: at line 3
>
>
> SQL> @rdbms/admin/tracetab.sql
> SP2-0310: unable to open file "rdbms/admin/tracetab.sql"

Relative pathnames are dangerous.
Make that ?/rdbms/admin/tracetab.sql
The ? is Oracle's shortcut for $ORACLE_HOME

Sybrand Bakker
Senior Oracle DBA Received on Wed Aug 06 2003 - 05:04:17 CDT