tk wrote:
> Hi Folks:
>
> I'm doing the examples on p.126/127 of the Oracle 8i Advanced PL/SQL
> programming book. I have 9i installed so I am not sure if this makes a
> difference. Mind you, I've only been doing this since Thursday of last
> week so I am VERY new to this and a moron.
>
> I created a user and have issued the following thru SQLPLUS
> --
> ALTER SESSION SET EVENTS '10938 trace name context level 10';
>
> ALTER PROCEDURE RaiseIt COMPILE DEBUG;
>
> -- Anonymous block which raises some exceptions.
> BEGIN
> CallRaise(1001);
> RaiseIt(-1);
> END;
> /
> --
>
> Then I go to the udump directory and examine the trace file and do *not*
> receive the stack trace like the book says I should. Rather I see the
> following in the trace file... Am I missing some type of setting/option in
> order to see the same call-stack trace that the book says I should see???
> I don't see any callstack trace in this trace file... Although, I can
> query the sys.plsql_trace_events and the sys.plsql_trace_runs table and see
> data in it. I just don't see it echoed to the following trace file.
>
> thanks in advance, Theron
>
> ============================================================================
> ==========================
>
> Dump file c:\oracle\admin\therons\udump\therons_ora_480.trc
> Tue Aug 05 19:47:14 2003
> ORACLE V9.2.0.1.0 - Production vsnsta=0
> vsnsql=12 vsnxtr=3
> Windows 2000 Version 5.0 Service Pack 2, CPU type 586
> Personal Oracle9i Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
> Windows 2000 Version 5.0 Service Pack 2, CPU type 586
> Instance name: therons
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 12
>
> Windows thread id: 480, image: ORACLE.EXE
>
>
> *** 2003-08-05 19:47:14.000
> *** SESSION ID:(10.229) 2003-08-05 19:47:14.000
> --NOTICE ---------------------------------------
> --PL/SQL TRACE INFORMATION IS NOW IN THE DATABASE
> -- To create the trace tables, use the script --
> -- rdbms/admin/tracetab.sql under ORACLE_HOME --
>
>
The book is out of date.
From SQL*PLUS do:
SQL> @rdbms/admin/tracetab.sql
PLEASE try to UNDERSTAND the contents of the trace file!
With 9i the results are placed inside the DB & NOT in a trace file.
Received on Tue Aug 05 2003 - 20:21:21 CDT
