REGEXP_REPLACE fails in Check Constraint in 12.2
We have check constraints that use the function REGEXP_REPLACE. They worked fine in the past but after the upgrade to 12.2 when we try to add them we get errors:
ORA-39083: Object type CONSTRAINT:"MY_TABLE" failed to create with error:
ORA-02436: date or system variable wrongly specified in CHECK constraint
Failing sql is:
ALTER TABLE "MY_TABLE" ADD CONSTRAINT "MY_CONSTRAINT" CHECK (REGEXP_REPLACE(CMD_PARAMETER_NAME,'["0-9a-zA-Z*+&/:#_.-]*') IS NULL) ENABLE
Does 12.2 not allow the use of the REGEXP_REPLACE function in check constraints?
Have the allowed regular experssions changed with 12.2?
thanks,
Michael