如何给oracl数据库blob字段插入超过32k的数据。谢谢

[beststone]

我用的是存储过程。
代码如下，只能插入32k以内的数据，郁闷
TMemoryStream *stream = new TMemoryStream();
stream->Write(pWorker->Photo,pWorker->PhotoLength);
proc->Parameters->CreateParameter("photo_in",ftOraBlob,pdInput,stream->Size,NULL);
proc->Parameters->ParamByName("photo_in")->LoadFromStream(stream,ftBlob);
哪位老大能帮我解决了？
不尽感谢！！！

[haixing0496]

要是用的是BDE的话,修改BDE设置中的Blob Size.一般默认的是32K!

[joshuazhao]

如果是ado的话就得使用oracle自己提供的驱动建一个连接，设置为>32k。
TMemoryStream *stream = new TMemoryStream();
stream->Write(pWorker->Photo,pWorker->PhotoLength);
proc->Parameters->CreateParameter( "photo_in",ftBlob,pdInput,pWorker->PhotoLength,NULL);
proc->Parameters->ParamByName("photo_in")->LoadFromStream(stream,ftBlob);
delete stream;
delete blob;