[sqr-users] DUAL table: String2Em: String to Decimal ObjectConversion Error

["April Wells" <x97wxp@hotmail.com>]

I keep getting the above error ((SQR 6806) String2Em: String to Decimal 
Object Conversion Error.)
when I select from DUAL. We've recently migrated our databases from Oracle 8 
to 10G which I know causes this error, and I was able to fix the error in my 
main SQR programs in a normal select (by putting a TO_CHAR around numeric 
fields with no scale), but I can't seem to resolve this error when selecting 
from the DUAL table.
ie.

....
$seq_type = ID_SEQ.NEXTVAL

BEGIN-SELECT ON-ERROR=fatal_error
[$seq_type]            &new_seq=NUMBER
FROM DUAL
END-SELECT

....
(SQR 6806) String2Em: String to Decimal Object Conversion Error.

Any suggestions greatly appreciated!

_________________________________________________________________
Don’t waste time standing in line—try shopping online. Visit Sympatico / MSN 
Shopping today! http://shopping.sympatico.msn.ca


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