Subject Re: [IBO] Selectable stored procedures and IBO
Author crazymenconnected
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
> Have you tested your EXECUTE PROCEDURE statement in IB_SQL?
>
> Helen
>

Normally i always check and debug the SQL code in IB_SQL. And i done it
this time too. But no error was reported it just compiled and runned
fine!
After another session of testing the procedure, i found out that the
problem was a blob field that was being passed as a parameter in the
SSP, something like this "EXECUTE PROCEDURE SSP(:ESP_BLOB_FIELD)". On
Delphi, whenever i try to use this field as a parameter, the exception
reported on my last post is thrown.

Im a bit more happy now, cause i know that the SSP's work, but how do i
update a blob field. Lets say a blob that holds an image, or any other
binary format? Can it be done this way?