Oracle Workflow Persistance - can bind a LONG value only for insert into a LONG

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
WilliamLee
Posts: 2
Joined: Tue 30 Apr 2013 16:26

Oracle Workflow Persistance - can bind a LONG value only for insert into a LONG

Post by WilliamLee » Tue 30 Apr 2013 16:34

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

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

Re: Oracle Workflow Persistance - can bind a LONG value only for insert into a LONG

Post by Shalex » Wed 08 May 2013 08:34

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.

Post Reply