Clob在asp.net的存储过程中插入的文档不超过4000个字符 [英] Clob not inserting a document more than 4000 characters in stored procedure from asp.net

问题描述

我有一个用于存储数据的存储过程，尤其是当我从plsql插入时要插入4000个字符以上的文档，这是在插入数据和文档，但是当我从asp.net项目中调用它时，它上传的文档不超过4000个字符，但它正在插入一个小文档.我正在这样插入

I have a stored procedure for inserting data and specially a document more than 4000 characters when i am inserting from plsql it is inserting data and document however when i am calling it from asp.net project it is not uploading a document more than 4000 characters but it is inserting a small document.I am inserting like this

Database _db = DatabaseFactory.CreateDatabase();
ReportTemplateSchema _schema=(ReportTemplateSchema)_envelope.GetMaster();
DbCommand cmd = _db.GetStoredProcCommand("INSRT");
_db.DiscoverParameters(cmd);
_db.AddInParameter(cmd, "Tmp_Document", DbType.Object, _schema.Document);
_db.ExecuteNonQuery(cmd);

ora-01460请求的未实现或不合理的转换是由于文档过大.

ora-01460 unimplemented or unreasonable conversion requested this is because of large document.

推荐答案

Oracle对可以发送到DBMS的命令和参数的完整大小有限制，您已经超出了该限制.有一组专门用于使用流或页面来读写Lob和Clob的功能.

Oracle has a limit on the full size of the command and parameters that can be sent to the DBMS, you're exceeding that limit. There are a set of functions specifically for reading and writing Lobs and Clobs using streams or pages that you should use instead.

请参见 http://www.codeproject.com/Articles/13675 ​​/在Oracle中使用C-for-Inserting-CLOB-Data-in ，以获取有关如何在.net中执行此操作的示例

See http://www.codeproject.com/Articles/13675/Using-C-for-Inserting-CLOB-Data-in-Oracle for an example of how to do this in .net

这篇关于Clob在asp.net的存储过程中插入的文档不超过4000个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！