Oracle JDBC Driver 188.8.131.52.0 Does Not Support The MATCH_RECOGNIZE Clause Giving Error: ORA-00907: missing right parenthesis
Last updated on JULY 10, 2018
Applies to:JDBC - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, Thin JDBC driver
Oracle JDBC driver 18.104.22.168.0 although certified with Oracle 12c database, does not support the MATCH_RECOGNIZE
- Using ODI 22.214.171.124.0 and the JDBC driver that comes with ODI 126.96.36.199.0 install ( 188.8.131.52.0 )
- An Oracle database 184.108.40.206.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 220.127.116.11.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms