Oracle JDBC Driver 184.108.40.206.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 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Thin JDBC driver
Oracle JDBC driver 22.214.171.124.0 although certified with Oracle 12c database, does not support the MATCH_RECOGNIZE
- Using ODI 126.96.36.199.0 and the JDBC driver that comes with ODI 188.8.131.52.0 install ( 184.108.40.206.0 )
- An Oracle database 220.127.116.11.0
Run the MATCH_RECOGNIZE clause from SQLPlus
--> This succeeds. Meaning there are no problems with the MATCH_RECOGNIZE feature
Run the exactly same MERGE command, on same database, from ODI 18.104.22.168.0
--> This fails with error: "java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis"
The issue has the following business impact:
Due to this issue, application that is using the MATCH_RECOGNIZE introduced in 12 c database fails.
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