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

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

This isn't real code, is it?  Do you mean:

let $seq_type = &ID_SEQ.NEXTVAL

or

let $seq_type = 'ID_SEQ.NEXTVAL'



-----Original Message-----
From: April Wells [mailto:x97wxp@hotmail.com] 
Sent: Wednesday, September 27, 2006 11:35 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] DUAL table: String2Em: String to Decimal
ObjectConversion Error

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

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