ORA-01461 with dapper

[josue.agnese]

Hi!

My environment:
Devart.Data.Oracle: 9.6.725
Devart.Data.Oracle.EFCore: 9.6.725
Dapper: 1.60.6
Oracle: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

After updating oracle dotConnect 9.6.675 to 9.6.725, my integrated test with a simple insert stopped working.

StackTrace:

INSERT INTO Products (Code, Color, CreationTime, CreatorUserId, DeleterUserId, DeletionTime, IsDeleted, LastModificationTime, LastModifierUserId, Price, ProductName, ProductSize)
VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11)
RETURNING ROWID INTO updatedRowid;
OPEN :outParameter FOR SELECT ProductId AS "ProductId" FROM Products WHERE ROWID = updatedRowid;
END;
Devart.Data.Oracle.OracleException (0x80004005): ORA-01461: can bind a LONG value only for insert into a LONG column
at ? .( , Int32 )
at ? .? ?(Int32 , )
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
...

I reproduced my scenario to share with you https://drive.google.com/open?id=1AvyHv ... ALYwXIBq8i
PS: Changing to version 9.6.675, it's work's again

[Shalex]

Thank you for your report. We will investigate the issue and notify you about the result.

[Shalex]

Your project successfully works with v9.6.725 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 in our environment.

Please remove the package Devart.Data.Oracle from your project and upgrade Devart.Data.Oracle.EFCore to v9.7.734. Does this help?

[Shalex]

We have reproduced the bug with v9.7.734 and Oracle Database 11g Express Edition Release 11.2.0.2.0. We will investigate it and notify you about the result.

[Shalex]

The bug with inserting a long string into the VARCHAR2 column on Oracle Server with NLS_CHARACTERSET=UTF8 in the Direct mode is fixed.

The internal build with the fix is available at https://www.devart.com/pub/nuget_oracle_9_7_756.zip.

[Shalex]

We will notify you when the new public build is available for download.

[Shalex]

New build of dotConnect for Oracle 9.7.770 is available for download now: viewtopic.php?f=1&t=38884.