[sqr-users] String2Em: String to Decimal Object ConversionError.

["Rey Camoras" <ReyC@MedImpact.com>]

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

------------------------------------------------------------------------------------------------------------------------
This transmission, together with any attachments, is intended only for the use 
of those to whom it is addressed and may contain information that is 
privileged, confidential, and exempt from disclosure under applicable law.  If 
you are not the intended recipient, you are hereby notified that any 
distribution or copying of this transmission is strictly prohibited.  If you 
received this transmission in error, please notify the original sender 
immediately and delete this message, along with any attachments, from your 
computer.


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