Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help a newbie trying to learn PL/SQL - No trace is showing up

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

From: tk <theronk_at_charter.net>
Date: Tue, 5 Aug 2003 19:53:43 -0600
Message-ID: <vj0k2noikkvocb@corp.supernews.com>


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;

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

Received on Tue Aug 05 2003 - 20:53:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US