i have an ORA-03120: two-task conversion routine: integer overflow since 9.14.1150.
Oracle Version: "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0" multitenant
.net core 3.1
If i change the devart Version to 9.13.1127 my Unit Test runs again.
sql:
Code: Select all
INSERT INTO T2003_PROCESS
(T2003_ID,
T2003_T2000_ID,
T2003_QUEUE,
T2003_SUBSCRIBER,
T2003_PRIO,
T2003_CONTENT,
T2003_COMPRESSED,
T2003_STATUS_ID,
T2003_LOOP,
T2003_CREATED_AT,
T2003_CREATED_BY,
T2003_MOD_AT,
T2003_MOD_BY)
VALUES (:T2003_ID,
:T2003_T2000_ID,
:T2003_QUEUE,
:T2003_SUBSCRIBER,
:T2003_PRIO,
:T2003_CONTENT,
:T2003_COMPRESSED,
1,
0,
SYSDATE,
USER,
SYSDATE,
USER)
Code: Select all
CREATE TABLE "T2003_PROCESS"
( "T2003_ID" NUMBER,
"T2003_T2000_ID" NUMBER,
"T2003_QUEUE" VARCHAR2(100 CHAR),
"T2003_SUBSCRIBER" VARCHAR2(100 CHAR),
"T2003_PRIO" NUMBER,
"T2003_CONTENT" BLOB,
"T2003_COMPRESSED" NUMBER(1,0),
"T2003_LOOP" NUMBER,
"T2003_MAINTENANCE_LOOP" NUMBER,
"T2003_STATUS_ID" NUMBER DEFAULT 0,
"T2003_STATUS_MSG" VARCHAR2(4000 CHAR),
"T2003_CREATED_AT" DATE DEFAULT sysdate,
"T2003_CREATED_BY" VARCHAR2(100 CHAR) DEFAULT user,
"T2003_MOD_AT" DATE DEFAULT sysdate,
"T2003_MOD_BY" VARCHAR2(100 CHAR) DEFAULT user)
Code: Select all
T2003_COMPRESSED false bool?
T2003_CONTENT {byte[66]} byte[]
T2003_CREATED_AT null System.DateTime?
T2003_CREATED_BY null string
T2003_ID 381837 decimal
T2003_LOOP null decimal?
T2003_MAINTENANCE_LOOP null decimal?
T2003_MOD_AT null System.DateTime?
T2003_MOD_BY null string
T2003_PRIO 100 decimal?
T2003_QUEUE null string
T2003_STATUS_ID null decimal?
T2003_STATUS_MSG null string
T2003_SUBSCRIBER "Test" string
T2003_T2000_ID 29765457 decimal?