Can't know what event anymore
- From: "Sinardy" <all_about_oracle@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Jul 2005 15:28:31 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
