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

From: Keld Nielsen <keldnielsen_at_tiscali.you.know.dk>
Date: Wed, 6 Aug 2003 04:05:13 +0200
Message-ID: <3f3062ef$0$32534$edfadb0f@dread16.news.tele.dk>

"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 !! Received on Tue Aug 05 2003 - 21:05:13 CDT