>END
>When I select this Proc., for example:
>Select * from NAME_PROC ('12/30/2003');
>Then, FB raise following error: 'Arithmetic exception, numeric
>overflow, or string truncation - isc 335544321'. Debugging, I
>watched that it execute up to the select inside "DO BEGIN".
>Anyone Can help me?
>
>

This is usualy when value is being assigned to variable is too big to
its datatype.
For example
declare variable A1 char (3);
A1 = '12' /* OK*/
A1 = '123' /* OK */
A1 = '1234' /* failure*/

I faced problem usualy when procedure has variable with less capacity
than data field;
with above sample (A1) , and if in table1 field is T1 char(4),
then for select T1 from table1 into :A1 raises such exception.


Adomas