Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

REGEXP_REPLACE fails in Check Constraint in 12.2

edited Oct 16, 2017 4:18PM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center