Subject | Re: [IBO] Selectable stored procedures and IBO |
---|---|
Author | crazymenconnected |
Post date | 2007-09-10T13:58:03Z |
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
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?
> Have you tested your EXECUTE PROCEDURE statement in IB_SQL?Normally i always check and debug the SQL code in IB_SQL. And i done it
>
> Helen
>
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?