Oracle JDBC Driver 11.2.0.3.0 Does Not Support The MATCH_RECOGNIZE Clause Giving Error: ORA-00907: missing right parenthesis
(Doc ID 2421414.1)
Last updated on AUGUST 01, 2023
Applies to:
JDBC - Version 11.2.0.3.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.2.0.3.0 version, Thin JDBC driver
Oracle JDBC driver 11.2.0.3.0 although certified with Oracle 12c database, does not support the MATCH_RECOGNIZE
- Using ODI 11.1.1.9.0 and the JDBC driver that comes with ODI 11.1.1.9.0 install ( 11.2.0.3.0 )
- An Oracle database 12.1.0.1.0
CASE A.
Run the MATCH_RECOGNIZE clause from SQLPlus
--> This succeeds. Meaning there are no problems with the MATCH_RECOGNIZE feature
CASE B.
Run the exactly same MERGE command, on same database, from ODI 11.1.1.9.0
--> This fails with error: "java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis"
ERROR
-----------------------
...
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, application that is using the MATCH_RECOGNIZE introduced in 12 c database fails.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |