ORA-00933: SQL command not properly ended:

[slaxman]

keyword END in the filter results in ORA-00933 error. Without that, it works fine. However, same query executed in Toad parses successfully. I am using oracle 19C with 'dontconnect for Oracle' 9.8.838.0

---------------------dbmonitor log--------------------
6/8/2020 10:32:08 AM 0.000 Creating object Complete
6/8/2020 10:32:08 AM 0.000 Prepare: SELECT DISTINCT user_id FROM Users WHERE Deleted = 1 AND user_id IN ('MUM7WA2','END9WA1','KIB4BH'); Complete
6/8/2020 10:32:08 AM 0.000 Execute: SELECT DISTINCT user_id FROM Users WHERE Deleted = 1 AND user_id IN ('MUM7WA2','END9WA1','KIB4BH'); Error
6/8/2020 10:32:08 AM 0.000 Creating object Complete

[Shalex]

1. Are you connecting in OCI Mode (via Oracle Client) or Direct Mode?

2. Try changing the mode to the other one. Are you getting the same error in this case?

[slaxman]

Original error was in direct mode. Just tried in OCI mode, still getting the same error.

[Shalex]

We cannot reproduce the error with the newest build v9.11.1034. Please upgrade.

If this doesn't help, specify:
1) are you connecting to the cloud or on-premise version of Oracle 19c?
2) in case of on-premise, did you install any patches?

[slaxman]

We are running on-premise without any patches. This is the version that query 'select * from v$version;' returns

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

[Shalex]

1. Confirm that you upgraded to v9.11.1034. In the debug mode via Debug > Windows > Modules, make sure that Devart.Data.Oracle.dll v9.11.1034 is loaded in the process of your application.

2. Does the error occur with the following code in your environment?

Code: Select all

CREATE TABLE DEPT (
DEPTNO NUMBER(4) CONSTRAINT PK_DEPT PRIMARY KEY,
DNAME VARCHAR2(14),
LOC VARCHAR2(13)
);
INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');

var monitor = new OracleMonitor() { IsActive = true };
var conn = new OracleConnection("Direct=True;Server=****;SID=****;User Id=****;Password=****;");
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT DISTINCT loc FROM dept WHERE deptno = 10 AND dname IN ('ACCOUNTING','END9WA1','KIB4BH')";
var result = cmd.ExecuteScalar();