Subject | updating blob via stored procedure |
---|---|
Author | John Elliott |
Post date | 2004-05-07T23:13:42Z |
I need to send the contents of a memo as one of several input parameters to
a stored procedure which then updates two tables. If I remove the reference
to the blob from the procedure it executes fine. However, when including the
blob I get a database error. It seems that sending the blob contents as a
string won't work.
I have been using a TIBCursor with SQL 'EXECUTE PROCEDURE FOO(PARAM1,PARAM2,
...)'
John Elliott
monkeebiz.com
[Non-text portions of this message have been removed]
a stored procedure which then updates two tables. If I remove the reference
to the blob from the procedure it executes fine. However, when including the
blob I get a database error. It seems that sending the blob contents as a
string won't work.
I have been using a TIBCursor with SQL 'EXECUTE PROCEDURE FOO(PARAM1,PARAM2,
...)'
John Elliott
monkeebiz.com
[Non-text portions of this message have been removed]