Migration InterBase 5.5 to 6.0

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:
A certain stored procedure caused me to get this error message:

ISC ERROR CODE: 335544321

ISC ERROR MESSAGE:
arithmetic exception, numeric overflow, or string truncation

Answer:

1. I found that a variable of type char(18) was assigned to another variable of type char(10). Since the data was never (?) longer than 8 characters, this worked fine up to version 5.5.
   Seems that IB 6.0 handles strings different. It is likely that a delcaration as VARCHAR instead of CHAR would help also.
   (See part 1 below)
   
   
2. Another necessary change was a type cast where IB 5.5 did an implicit conversion.
   

	// part 1 declare variable v1 char(10); declare variable v2 char(18); .. v1 = v2; // generates the error in IB 6.0 // part 2 declare variable vchardate char(18); declare variable vdatedate date; vchardate = '1996-Jan-15'; vdatedate = vchardate; // generates error in IB 6.0 vdatedate = cast (vchardate as DATE);

Comments:

2008-03-19, 05:18:09

anonymous from Lebanon

Keywords:

Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option.
It seems that you are from Washington, US . Info/ Feedback on this	Show city and country Show country only Hide my location
Leave your comment here:
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.