At 10:17 AM 30/11/2004 +0000, you 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

It looks as though one of your variables is too small to accommodate the
selected data. Make sure that the variables are the same size and type as
the source columns.

./hb