Subject | Input BLOB parameter problem in Stored Procedure |
---|---|
Author | Sergio |
Post date | 2008-02-11T20:55:31Z |
Hi. FB 1.5.3 SS in W2K. I have a SP:
CREATE PROCEDURE My_SP (
SomeParams ...,
MyBLOBParam BLOB sub_type 0 segment size 80,
MoreParams ...)
AS
....
I invoke that SP from another SP, and when I put some string in the Blob
param, I received the following error:
"Arithmetic overflow or division by zero has occurred. arithmetic
exception, numeric overflow, or string truncation."
When the blob is NULL everything is OK. I use the BLOB parameter "only" in
an INSERT statement.
The line to invoke:
EXECUTE PROCEDURE My_SP (..someparams.., 'A string not bigger that 100
characters', .. moreparams..);
What's wrong?
Sergio
CREATE PROCEDURE My_SP (
SomeParams ...,
MyBLOBParam BLOB sub_type 0 segment size 80,
MoreParams ...)
AS
....
I invoke that SP from another SP, and when I put some string in the Blob
param, I received the following error:
"Arithmetic overflow or division by zero has occurred. arithmetic
exception, numeric overflow, or string truncation."
When the blob is NULL everything is OK. I use the BLOB parameter "only" in
an INSERT statement.
The line to invoke:
EXECUTE PROCEDURE My_SP (..someparams.., 'A string not bigger that 100
characters', .. moreparams..);
What's wrong?
Sergio