RE: [sqr-users] (SQR 6806) String2Em: String to Decimal Object Conversion Error.

[Peter Burton <pburton@brio.com>]

Steve,

This is because Oracle made a change in 9.2.0.3.

Have a DBA issue the following command:

alter system set event='10499 trace name context forever,level 1' 
COMMENT='return 0 for the scale if NUMBER created without specifying the
scale'
SCOPE=SPFILE

Peter

> -----Original Message-----
> From: Alexander, Steve [mailto:Steven.Alexander@sanjoseca.gov]
> Sent: Friday, October 17, 2003 11:34 AM
> To: SQR User Group (E-mail)
> Subject: [sqr-users] (SQR 6806) String2Em: String to Decimal Object
> Conversion Error.
> 
> 
> When I got this error message a few weeks ago, I dealt with 
> it by rewritting
> the program.  Now I've got it again, on a 
> Peoplesoft-delivered program,
> BEN040.  Both programs used to work, and I've just realized that they
> stopped working on our STAGE database when we upgraded from 
> Oracle 8.1.7.4
> to 9.2.0.3.  BEN040 still works in PROD, which is still at 
> Oracle 8.1.7.4.
> Does anyone know of a bad SQR 6/Oracle 9 interaction?
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users