RE: Event 10499: NUMBER Datatypes

  • From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
  • To: <gampert@xxxxxx>
  • Date: Thu, 31 Mar 2005 20:55:03 +0100

Hi Gilberto,
you might want to check MetaLink for the details of that bug. what problem are
you struggling with?
who told you that you need to set this event? I guess they also provided a good
reason :-)

if you want to doublecheck whether the event is really active,
you might want to execute the procedure sys.dbms_system.read_ev(10499,level)
and check the return value of level.

kind regards,

Lex.
 
---------------------------------------------
Visit my website at http://www.naturaljoin.nl
---------------------------------------------

-----Original Message-----
From: Gilberto Gampert [mailto:gampert@xxxxxx] 
Sent: Thursday, March 31, 2005 20:49
To: Lex de Haan
Subject: Re: Event 10499: NUMBER Datatypes

Sorry, i forgot the details.
I´m using Oracle 9i 9.2.0.6  and not using Oracle Spatial.
About the bug 2235818, i think that you´re right...

------------------------------
Gilberto Gampert
Supervisor Desenv. de Sistemas
Divisão de TI - UPF





Lex de Haan escreveu:

>what version are you running?
>are you using Oracle Spatial, by any chance?
>do you suffer from bug 2235818?
>
>in 10g, the event won't work anymore.
>
>
>kind regards,
>
>Lex.
> 
>---------------------------------------------
>Visit my website at http://www.naturaljoin.nl
>---------------------------------------------
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx 
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gilberto Gampert
>Sent: Thursday, March 31, 2005 20:17
>To: oracle-l@xxxxxxxxxxxxx
>Subject: Event 10499: NUMBER Datatypes
>
>Hi guys!
>
>Setting Event 10499 to revert to the earlier behavior of NUMBER 
>datatypes that have no explicit setting of their scale value was no 
>expected effect on my Oracle database. What i´m doing wrong? I included:
>event="10499 trace name context forever, level 10" in the init<sid>.ora 
>and created the spfile. Then, shutdown and startup. Nothing happens. 
>The new behavior still remains the same.
>
>Any help ?
>
>--
>------------------------------
>Gilberto Gampert
>Supervisor Desenv. de Sistemas
>Divisão de TI - UPF
>
>
>
>
>
>  
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 30/03/2005
>  
>


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.6 - Release Date: 30/03/2005


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

Other related posts: