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

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:1060199782.580167_at_yasure...
> 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.
>

Quite right, I was just trying point to excatly that in reply to "With 9i the results are placed inside the DB & NOT in a trace file"

Best regards,
Keld

> --
> 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 - 15:49:13 CDT