[sqr-users] Re: DUAL table: String2Em: String to DecimalObjectConversion Error

[Nathan Stratton Treadway <nathanst@ontko.com>]

On Mon, Oct 02, 2006 at 05:28:22AM -0400, Peter Burton wrote:
> 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
[...]
> Therefore, you need to upgrade you version of SQR Server to at least 8.1
> or always return a character and then have SQR convert it a number
> before you use it.

At the client site where I ran into this problem they did end up
implementing the "event 10499" fix eventually (and they will have
upgraded to SQR v8.x before they move to Oracle v10.x.) -- and thus I no
longer need to use source-code changes to work around the String2Em
error, and don't have an environment in which I can test the long-term
operation of such changes.

However, while I was waiting for the EVENT fix to be implemented, I was
able to get the SQR programs to work again against the Oracle 9
instances by using ROUND() on the columns/expressions that were
producing the error.  This seems to work by specifying an explict scale
for the expression, which avoids the "unspecified-scale" situation that
triggers the problem.

I can certainly see how using TO_CHAR() would also avoid the error, but
I'm wondering if you know of any specific situations where the ROUND()
workaround would fail and _only_ TO_CHAR() would work?

Thanks.

                                                        Nathan
----------------------------------------------------------------------------
Nathan Stratton Treadway  -  nathanst@ontko.com  -  Mid-Atlantic region
Ray Ontko & Co.  -  Software consulting services  -   http://www.ontko.com/
 GPG Key: http://www.ontko.com/~nathanst/gpg_key.txt   ID: 1023D/ECFB6239
 Key fingerprint = 6AD8 485E 20B9 5C71 231C  0C32 15F3 ADCD ECFB 6239

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