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.
精彩评论