Unable to pass parameter OracleParameter.Value > 4k

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Devendra
Posts: 8
Joined: Wed 16 Mar 2011 12:34

Unable to pass parameter OracleParameter.Value > 4k

Post by Devendra » Mon 05 Sep 2011 09:09

Hi Shalex,

Thanks for the reply.
The details of your points are given below:
1) I have verified the Devart dll version by navigate to the Debug > Windows > Modules menu. Sample application loads 6.10.126 version of Devart.Data.Oracle.dll.
2) We can provide you dummy data for test purpose if require but this problem is related to the parameter size.
3) When adaptor fills the data into data table then below error occurs.
ORA-01460: unimplemented or unreasonable conversion requested

Note: We got this error only if we have OracleParameter value length greater than 4k. If we reduce the length less than 4k then it works perfect.

Please share you email ID so that I can send you screen shot.

Thanks
Sachin

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 08 Sep 2011 14:12

Sachin,
Please send us the following information via http://www.devart.com/company/contact.html:
2) the DML script to fill the TEST_WELL_RES_MAT_VIEW table, because the size of the "whereClause" parameter is greater than 4k (4603 - calculated at runtime) in Devendra's test project;
3) the line of code where the error occurs. A call stack will be also appreciated;
4) the version of your Oracle server and its NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET settings.

Post Reply