Re: [sqr-users] (SQR 6806) String2Em: String to Decimal Object ConversionError.

[amy.harvel@phoenix.gov]

Funny -- we had the same error yesterday -- there is a work around -- DONT 
change any SQR's.


Find Solution id 200744351 on PeopleSoft's web.

What we found was the select works in Oracle -- not in SQR -- issue is the 
numbers (comment them out in the SQR or make them to_char).  Describe the 
view -- notice the numbers are just Number's not Number(38) or number 
(5,2) -- SQR can't handle a number that has not length.  The solution 
fixes the problem -- its an Oracle "behavior change"


Amy M. Harvel
City Of Phoenix Information Technology Department
Programmer III
602-261-8974




"Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
Sent by: sqr-users-admin@sqrug.org
10/17/2003 08:34 AM
Please respond to sqr-users

 
        To:     "SQR User Group (E-mail)" <sqr-users@sqrug.org>
        cc: 
        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