Devart Forums

Hello,

After updating from 8.3.2 (version october) to version 8.4.1, a simple insert in a database fails.

insert into Sys_Usuario_Acceso(IDACCESO ,IDUSUARIO, ROLE_USUARIO,IDESTACION,FECHA_ENTRADA,FECHA_SALIDA)
values(:IDACCESO,:IDUSUARIO,:ROLE_USUARIO,:IDESTACION,:FECHA_ENTRADA,:FECHA_SALIDA)

:IDACCESO = number(18,4), value 123456
:IDUSUARIO = number(5,0) and value 0
:ROLE_USUARIO = varchar(31), and value ''
:IDEstacion = number(5,0) and value = 55
:FECHA_ENTRADA = timestamp, and value '08/03/2021 12:00:00', of course date time variable
:FECHA_SALIDA = timestamp, and I'm setting a null value.

When executing this simple insert I get, before the exception I get an error in debugger with a set of numbers + leters

ORA-01461: can bind a LONG value only for insert into a LONG column.

We haven't been able to reproduce the issue on none of our test servers with different parameters. Please send us a sample project demonstrating the issue. Also we need the DDL script that creates the tables that you use in the sample project. For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

Hello,

We are going to make a project that demonstrates the problem,
We have isolated the source and is in the parameter of type string ROLE_USUARIO.

If we set '' to the parameter raises an exception, if we set null all runs fine.

The same problem occurs with all queries where we set to varchar2 fields empty string '' instead of null null string with Oracle.

We have update to version 8.4.2. Now the error that you said that you can't reproduce is corrected, but another error raises when freeing a query. It raises an access violation.

Please send us a sample project demonstrating the Access Violation error

I have sent you an example by email. So simple to reproduce.

Thank you for sending us the trace file. We didn't receive a sample project, however. Could you send us a project demonstrating the issue?