good day Dmitry
=-0=-0-=0-==-0=-0

thanks for the tip.

I have looked but dont see any problem. I am including the problen SP.
Please forgive if it seems foreign. Please note that the field sizes returned are all the correct size AS in the tables.

Any help will be appreciated.

//================ START ============================
CREATE PROCEDURE KRY_FOOI_TOTAAL_VIR_VERW_DOKTOR (
BEGIN_DT DATE,
EIND_DT DATE
) RETURNS (
KODE VARCHAR(5),
VAN VARCHAR(20),
TOTAAL NUMERIC(15, 2)
) AS
BEGIN

for select distinct(a.primary_doctor),r.surname
from account a,referring_doctor r
where a.primary_doctor = r.code
and r.date_entered >= :BEGIN_DT
and r.date_entered <= :EIND_DT into :KODE,:VAN do begin


select sum(f.cost)/100 from fees f,account a
where f.feed=1 and f.acc_code = a.acc_Code
and a.primary_doctor = :KODE and a.date_entered >= :BEGIN_DT
and a.date_entered <= :EIND_DT into :TOTAAL;
suspend;
end
//======================= END ==============================

Thanks


At 08:44 AM 28/06/2006, Dmitry Yemanov wrote:

>"Johannes Pretorius" <johannes@...> wrote:
>>
>> gbak: ERROR: arithmetic exception, numeric overflow, or string truncation
>> gbak: Exiting before completion due to errors
>
>Check your SPs for concatenation of long strings (producing more than 32K as
>a result row).
>
>
>Dmitry
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://www.firebirdsql.org and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>