Subject Re: [firebird-support] Line Break in SP
Author Helen Borrie
At 09:05 AM 2/08/2004 -0300, you wrote:
>Thanks Helen !
>But now, I see, another problem..
>It's the first time that I work with Blobs in an SP.. the BLOB Result aways
>out blank !! :(
>If I do some like BLOB_Variable=VARCHAR_Variable; the server return me an
>error when I execute "Unsuccessful execution caused by a system error that
>precludes....". If i make and concatenation like VARCHAR_Variable1 || ' - '
>|| VARCHAR_Variable2 the error don't ocurrs but it return me blank... :(
>I tried to make an Cast to blob but it don't run..

You can't assign a string to a blob variable and you can't cast a string as
a blob. You can only insert a string into a blob column, or use a string
to update a blob column.

>What happen ???

A blob isn't a string. In DSQL only, you can pass a string constant (not a
string parameter) to a text blob column. This is OK:

insert into aTable(idfield, textblobfield)
values (99, "I want to be a blob!');

update aTable
set textblobfield = 'I want to be a blob, too!'
where idfield = 100;

You can't pass a string to a blob parameter.