Now I found it has nothing to do with the blob I was returning but with
concatination off 2 varchars.

Try creating this procedure. You'll get the error.

CREATE PROCEDURE TEST$VARCHAR
AS
DECLARE VARIABLE varTest1 VARCHAR(20000);
DECLARE VARIABLE varTest2 VARCHAR(32000);
BEGIN
/* Procedure body */
varTest2 = 'Test';
varTest1 = 'Concatinated';
varTest2 = varTest2 || varTest1;
SUSPEND;
END

Try Also with FB1.RC2 and it will work.

Raf


Raf Schandevyl wrote:

>After Some test I've seen that its not as simple as create a procedure
>that returns a blob.
>
>Is it ok if I send my backup file to you ?
>
>Raf Schandevyl
>
>Claudio Valderrama C. wrote:
>
>>"Raf Schandevyl" <Raf.Schandevyl@...> wrote in message
>>news:3C90A255.3020908@......
>>
>>>Since I installed the latested version i've problems with my stored
>>>procedures returning blob variables.
>>>
>>>I'm getting the following error when restoring the database.
>>>
>>>Implementation limit exceeded.
>>>block size exceeds implementation restriction.
>>>
>>Raf:
>>I've not seen the error myself, but I really love your explicit clue. Why
>>can't other people do the same? The problem should be with blobs, then. I
>>was trying to figure out how a field could be longer than the allowed
>>implementation or DSQL would have complained already at creation time. Blob
>>handling's the path that should be tracked inside the engine.
>>If the issue is not as easy as simply creating a procedure that returns a
>>blob in an output param and do backup/restore, please reply.
>>
>>I don't intend to explain still what I fixed that caused such a side effect.
>>
>>C.
>>--
>>Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
>>Independent developer
>>Owner of the Interbase® WebRing
>>
>>
>>To unsubscribe from this group, send an email to:
>>ib-support-unsubscribe@egroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>>
>>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>

[Non-text portions of this message have been removed]