Error in 8.4.1 with Oracle

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Error in 8.4.1 with Oracle

Post by cointec » Tue 09 Mar 2021 07:25

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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Error in 8.4.1 with Oracle

Post by MaximG » Wed 10 Mar 2021 22:00

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

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: Error in 8.4.1 with Oracle

Post by cointec » Mon 29 Mar 2021 14:46

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.

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: Error in 8.4.1 with Oracle

Post by cointec » Mon 29 Mar 2021 15:15

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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Error in 8.4.1 with Oracle

Post by MaximG » Mon 29 Mar 2021 16:46

Please send us a sample project demonstrating the Access Violation error

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: Error in 8.4.1 with Oracle

Post by cointec » Mon 29 Mar 2021 16:57

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

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Error in 8.4.1 with Oracle

Post by MaximG » Fri 02 Apr 2021 14:09

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?

Post Reply