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