RE: [sqr-users] String to Decimal Object Conversion Error with Oracle 9

[Peter Burton <pburton@brio.com>]

>> This is an Oracle induced error <<

Run this (as the DBA) on the affected server:

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

Peter

-----Original Message-----
From: Mikeshock, Lynn [mailto:LMikeshock@rgare.com]
Sent: Tuesday, April 15, 2003 10:32 AM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] String to Decimal Object Conversion Error with
Oracle 9


We are running SQR version 8.15 with an Oracle 9.2.0.3 database on a
PeopleSoft application.   The program aborts with the error '(SQR 6806)
String2Em: String to Decimal Object Conversion Error' when running the
following select statement using Oracle 9 but completes successfully when
using Oracle 8.1.7.4.  

begin-SELECT On-Error=SQL-Error
D.INITIAL_EXTENT &D.INIT
D.NEXT_EXTENT    &D.NEXT
D.MAX_EXTENTS    &D.MAXEXT
D.PCT_INCREASE   &D.PCT
D.PCT_FREE       &D.PCTFREE
   
   show 'Got a record'

FROM USER_INDEXES D
WHERE INDEX_NAME = $IndexName
end-SELECT

The field causing the problem is MAX_EXTENTS.  The value in it is
2147483645, but that's also the value in the Oracle 8 database where the
program works.  If I take MAX_EXTENTS out of the select, all works fine.
Has anyone else that's using Oracle 9 had this problem and know what the
solution to it is?

Thanks.

Lynn


_______________________________________________
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