--- In firebird-support@yahoogroups.com, "carlos_arguilar"
<carlos_arguilar@y...> wrote:

>
> I've a stored procedure like this:
> CREATE PROCEDURE NAME_PROC (DATE_ DATE)
> RETURNS (CUSTOMER VARCHAR(13), VALUE_ NUMERIC(18,2), NAME VARCHAR
> (50))
> AS
> BEGIN
> FOR SELECT FIN_CUST_COD, FIN_CUST_VALUE FROM FINANCE WHERE
> FIN_CUST_PAY_DATE = :DATE_ INTO :CUSTOMER, :VALUE_
> DO BEGIN
> SELECT CUST_NAME FROM CUSTOMER WHERE CUST_COD = :CUSTOMER
> INTO :NAME;
> .
> .
> .
> SUSPEND;
> END
> 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?
> Thanks,
> Carlos Arguilar

I also seem to get this same error if I put the wrong data type into a
column (eg a string into an int column).