RE: [sqr-users] String2Em: String to Decimal Object Conversion Error.

["Bob Stone" <bstone@fastenal.com>]

It's not SQR attempting it, it's Oracle.  We had the same issue with our
9i upgrade, and I believe it should work for 10g.  If it's easier to
alter all the tables to specify the columns, that's probably your best
bet.  The other option is to always call it using "to_number" or
"to_char" in the select.   

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Knapp, Richard
Sent: Tuesday, August 01, 2006 11:26 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion
Error.


Ray,

I'm baffled as to why SQR is attempting a conversion.

I think you are right - altering the db columns sounds like the easiest
fix.

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Rey Camoras
Sent: Tuesday, August 01, 2006 10:41 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion
Error.

Same thing happens:     (SQR 6806) String2Em: String to Decimal Object
Conversion Error.

If only we could upgrade to version 8.3.x.  We can't because management
doesn't deem it necessary. 

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu] 
Sent: Monday, July 31, 2006 8:41 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion
Error.


Ray,

If you refer to the column in your select as &employee_id, what happens?

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Rey Camoras
Sent: Monday, July 31, 2006 10:27 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion
Error.

 If I don't select an unscaled number column, the statement works fine.
Our best option might be to redefine all of our unscaled numbers in our
database.

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu]
Sent: Friday, July 28, 2006 8:33 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] String2Em: String to Decimal Object Conversion
Error.


What happens if you leave the &empId out?

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Rey Camoras
Sent: Friday, July 28, 2006 10:14 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] String2Em: String to Decimal Object Conversion
Error.



This is an old issue revisited...

We're in the process of migrating our databases from Oracle 8 to 10G.
However, we're getting an error message in SQR when selecting a number
column that isn't scaled (defined as number, as opposed to number(10),
for example).  We're using SQR version 6.0 on SunOS, release 5.8.


begin-program
begin-select
employee_id &empId

from emp
end-select
end-program

Error on line 3:
   (SQR 6806) String2Em: String to Decimal Object Conversion Error.

SQR: Program Aborting.

However, if I add number such as 0 to the selected column, it works
fine, but it's not the ideal solution; we would have to change thousands
of sqr program to fix this issue.

begin-program
begin-select
0+employee_id &empId

from emp
end-select
end-program

I found this old sqr user group solution for Oracle 9i from 2003.  Does
anyone know if this works for Oracle 10G?  If not, does anyone know any
other fixes?

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



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