SQLcl 18.2 Fails with Error "Non Supported SQL92 Token at Position: 108" When Use MATCH_RECOGNIZE
(Doc ID 2458245.1)
Last updated on DECEMBER 14, 2020
Applies to:
Oracle SQL Developer - Version 18.2 to 18.4Oracle SQLcl - Version 18.4 to 18.4 [Release 18]
Information in this document applies to any platform.
Symptoms
SQLcl 18.2 fails with the following error when match_recognize is used:
Error:
Error report -
Non supported SQL92 token at position: 108
Non supported SQL92 token at position: 108
It appears that the match_recognize braces are not parsed in SQLcl 18.2, and there may be an incompatibility in SQLcl ( or perhaps ojdbc8 ) parsing of the "{}" tokens in match_recognize.
For Example:
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 |