Page 2 of 2

Unable to pass parameter OracleParameter.Value > 4k

Posted: Mon 05 Sep 2011 09:09
by Devendra
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

Posted: Thu 08 Sep 2011 14:12
by Shalex
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.