Devart Forums

Hi,

we purchased the devArt Oracle DotConnect and were using the DevArt.Data.Oracle.WorkflowFoundation to perform workflow persistence. We noticed that when our data gets large ( >1MB), we encountered a persistence exception that says
"ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512 at INSTANCESTORELOGIC...."

My versions of DLL are as follow:
Devart.Data.dll V5.0.581.0
Devart.Data.Oracle V7.2.122.0
Devart.Data.Oracle.WorkflowFoundation V7.2.122.0

Any one happen to have a solution for this?

Thanks,
William

1. Please upgrade to the latest (7.7.226) version of dotConnect for Oracle using the credentials (URL, account name, and password) that were sent to you after the purchase of our product. If you have not received this information, please contact our Sales department (sales at devart*com) to renew your credentials.

2. This error occurs when there is a mismatch between data types of .NET parameter and Oracle parameter/column. Try to localize the issue: turn on the dbMonitor tool, specify the exact SQL which fails and the data types/values of its parameters.
http://www.devart.com/dotconnect/oracle ... nitor.html
http://www.devart.com/dbmonitor/dbmon3.exe

3. There are two versions of scripts and Devart.Data.Oracle.WorkflowFoundation.dll:
a) for .NET 4.0 (in the root of the \Program Files (x86)\Devart\dotConnect\Oracle\WF Services\ folder)
b) for .NET 4.5 (in the \Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\ folder)
Workflow Foundation 4.5 is supported by dotConnect for Oracle starting from the 7.7.217 build.
You are working with .NET 4.0, aren't you?

4. If possible, send us a small test project to reproduce the issue in our environment.