RE: [sqr-users] Error encountered

["Peter Burton" <Peter_Burton@hyperion.com>]

Ram,

The problem here is that Oracle 9.2.0.3 changed they way they return
numerical values without specifying a scale.  SQR Server 8.1 was
modified to handle both the old and new mechanisms.  Oracle provided a
work-around --

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

but that fix will not work in Oracle 10g -- this was by design from
Oracle.

Therefore, you have three options:

        1) Upgrade you version of SQR Server to at least 8.1
        2) Modify your SQL to return it as a character strings
        3) Modify your SQL to use the Oracle ROUND() function

Peter

-----Original Message-----
From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf
Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Monday, October 16, 2006 10:00 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Error encountered

Hi All,

        Iam getting the following error when i execute the below code
        Error - 
        (SQR 6006) String 2Em -  String To Decimal Object Conversion
Error 


        Code -

        BEGIN-SELECT
        COUNTM &COUNTTMR
        LET #COUNT = &COUNTTMR
        LET $COUNT = ROUND(#COUNT,0)
        !Others,Matchingrows,302635
        Let $WRITE_SUM_LINE = 'Others' ||'^'||'Matchingrows'|| '^' ||
$COUNT
        Write 99107 From $WRITE_SUM_LINE
        FROM
        (
        SELECT COUNT(1) COUNTM
        FROM PS_GE_QA_CMP_LINE_DTL
        WHERE DRIVER_CODE = $upp_filepath
        )
        END-SELECT


Thanks in Advance
Ram

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


If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited. Internet communications are not secure and Hyperion does 
not, therefore, accept legal responsibility for the contents of this message 
nor for any damage caused by viruses. The views expressed here do not 
necessarily represent those of Hyperion. For more information about Hyperion, 
please visit our Web site at: www.hyperion.com



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