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

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

Postby 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
WilliamLee
 
Posts: 2
Joined: Tue 30 Apr 2013 16:26

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

Postby 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/docs/?dbmonitor.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.
Shalex
Devart Team
 
Posts: 7475
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle