Name
ORA-12731: invalid collation class in regular expression
Synopsis
You specified a collation element that does not exist in your current
sort order. For example, specifying [.ch.]
when
NLS_SORT is other than XSPANISH or XCZECH will cause this error,
because other languages never treat the combination
'ch
' as a single character. Check your expression
to be sure that each use of [=
and
=]
is valid, and check your NLS_SORT setting.
Get Oracle Regular Expressions Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.