Can't know what event anymore

From: Sinardy <all_about_oracle_at_hotpop.com>
Date: Mon, 11 Jul 2005 15:28:31 +0800
Message-ID: <009001c585ea$2a1cd020$0400a8c0@ncs.corp.intads>

Hi all,

whats wrong with this?

I expect to see what event that I have.

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Jul 11 15:25:24 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> ALTER system SET EVENTS='10938 TRACE NAME CONTEXT LEVEL 12';

System altered.

SQL> set serverout on
SQL> declare
  2 l_event number;
  3 begin

  4     sys.dbms_system.read_ev( 10938, l_event );
  5     dbms_output.put_line( '0 = FALSE, 1 = TRUE, and your result is ' ||

l_event );
  6 end;
  7 /
0 = FALSE, 1 = TRUE, and your result is 0

PL/SQL procedure successfully completed.

SQL> Regards,
Sinardy

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 11 2005 - 02:30:03 CDT