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

["Mikeshock, Lynn" <LMikeshock@rgare.com>]

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