Keld Nielsen wrote:
>"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
>news:lKYXa.37861$Ne.17172_at_fed1read03...
>
>
>>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
>>
>>
>
>wrong ! it's in ORACLE_HOME ... etc as clearly stated in the
>OP's mail - or can't you read ?
>
>
>
>>PLEASE try to UNDERSTAND the contents of the trace file!
>>
>>
>
>any reason to yell ? The contents of the file ? As you give the impression
>that you know, would you care to share ?
>
>
>
>>With 9i the results are placed inside the DB & NOT in a trace file.
>>
>>
>>
>Oh, we don't have a choice anymore !!
>
>
>
Trace files are still put into UDUMP just as always if you follow the
directions.
--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Aug 06 2003 - 14:54:18 CDT
