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