| Subject | Re: [firebird-support] Blob parameters to stored procedures |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-01-17T03:41:07Z |
At 04:22 PM 16/01/2005 +0000, you wrote:
then pass a string parameter to it.
If you want to pass a string to a SP for use as a text blob, you must
declare the input parameter as a VARCHAR() of adequate size and pass it to
the blob in the update or insert statement within the SP. Note that
varchars for use with blobs must not exceed 32,765 bytes. You need to bear
this in mind when passing varchars from your applications and also if your
SPs perform concatenation. Only one string can be given to a blob: there
is no way to "append" a string to a blob.
./heLen
>Is it ok to pass (and return) blobs to stored procedures in FB1.5.2?Yes, as ever.
>I remember reading something way back about them not working in PSQL.What doesn't work is to declare a blob as an input parameter in a SP and
then pass a string parameter to it.
If you want to pass a string to a SP for use as a text blob, you must
declare the input parameter as a VARCHAR() of adequate size and pass it to
the blob in the update or insert statement within the SP. Note that
varchars for use with blobs must not exceed 32,765 bytes. You need to bear
this in mind when passing varchars from your applications and also if your
SPs perform concatenation. Only one string can be given to a blob: there
is no way to "append" a string to a blob.
./heLen