开发者

Insert Blob data using stored procedure in DB2 by .net

开发者 https://www.devze.com 2023-03-21 11:33 出处:网络
How can I insert blob data to DBB2 using stored procedure in .net? When I insert blob data by sql string = INSERT INTO tblDemo(IDFile,Content) values(?,?)

How can I insert blob data to DBB2 using stored procedure in .net?

When I insert blob data by sql string = INSERT INTO tblDemo(IDFile,Content) values(?,?) and add DB2开发者_Go百科Parameters for DB2Command ==> Run ok

Then I write a stored procedure to insert into tblDemo

CREATE PROCEDURE sp_ADD(v_IDFile GRAPHIC(10),
v_Content BLOB(2047M)) LANGUAGE SQL
BEGIN
   insert into tblDemo(IDFile,
    Content)
values(v_IDFile ,
    v_Content);
END

and run DB2Command, I get error:

ERROR [57011] [IBM][DB2/NT] SQL0930N There is not enough storage available to process the statement. SQLSTATE=57011

How can I do that?


Maybe you must adjust the "UDF Shared Memory" (udf_mem_sz) setting.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号