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

From: tk <theronk_at_charter.net>
Date: Wed, 6 Aug 2003 08:13:26 -0600
Message-ID: <vj1vdmksph0lc6@corp.supernews.com>

> > SQL> @rdbms/admin/tracetab.sql
> > SP2-0310: unable to open file "rdbms/admin/tracetab.sql"
>
>
> Relative pathnames are dangerous.
> Make that ?/rdbms/admin/tracetab.sql
> The ? is Oracle's shortcut for $ORACLE_HOME
> Senior Oracle DBA

I'm running Oracle 9i on Windows 2000 on my PC. I don't know if that makes a difference.... My ORACLE_HOME is not set (when I do echo %ORACLE_HOME%) even though I installed Oracle successfully. I get the following error (and I know there's data in the trace) when I try and issue the command:

SQL> ALTER SESSION SET EVENTS '10938 trace name context level 5';

Session altered.

SQL>
SQL> -- Anonymous block which raises some exceptions.
SQL> BEGIN

  2 CallRaise(1001);
  3 RaiseIt(-1);
  4 END;
  5 /
BEGIN
*
ERROR at line 1:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "TKOUSEK.RAISEIT", line 7
ORA-06512: at line 3

SQL> ?/rdbms/admin/tracetab.sql
SP2-0172: No HELP available.
SQL> Received on Wed Aug 06 2003 - 09:13:26 CDT