Subject | Message length error |
---|---|
Author | Bob Murdoch |
Post date | 2006-12-12T02:54:12Z |
I am having a strange problem with an FB 1.5 database.
In a before insert trigger on a table, I call 'execute procedure' to
calculate a billing rate. This same concept has been used any number
of times in other applications and programs that I've written.
However, in this application, I am receiving an error message of
'Message length error (encountered 62, expected 66)'.
The code in the after insert trigger looks like this:
...
execute procedure calc_billing_rate(:vItemID, new.billing_code)
returning_values :vBillingRate;
...
I've narrowed the code in the stored procedure to simply:
create procedure calc_billing_rate(id integer, billing_code char(5))
returns (billing_rate numeric(9,2))
as
begin
billing_rate = 0.0;
end
After looking thru past entries on this list, I have tried adding a
'suspend' to the SP. I have tried changing the 'execute procedure' to
a select within the trigger. Both have the same error.
The database backs up and restores without error.
Going crazy,
Bob M..
In a before insert trigger on a table, I call 'execute procedure' to
calculate a billing rate. This same concept has been used any number
of times in other applications and programs that I've written.
However, in this application, I am receiving an error message of
'Message length error (encountered 62, expected 66)'.
The code in the after insert trigger looks like this:
...
execute procedure calc_billing_rate(:vItemID, new.billing_code)
returning_values :vBillingRate;
...
I've narrowed the code in the stored procedure to simply:
create procedure calc_billing_rate(id integer, billing_code char(5))
returns (billing_rate numeric(9,2))
as
begin
billing_rate = 0.0;
end
After looking thru past entries on this list, I have tried adding a
'suspend' to the SP. I have tried changing the 'execute procedure' to
a select within the trigger. Both have the same error.
The database backs up and restores without error.
Going crazy,
Bob M..