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 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 -- //www.freelists.org/webpage/oracle-l