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

["Knapp, Richard" <KnappR@umsystem.edu>]

I think your problem is in your error handling procedure.  No conversion 
happens in the SQL you have shown us and I successfully tested your code on a 
9i db removing reference to the error handler.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: Mikeshock, Lynn [mailto:LMikeshock@rgare.com]
Sent: Tuesday, April 15, 2003 9: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