开发者

Insert Blob data using stored procedure in DB2 by .net

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜