Oracle Error Message
ORA-28078: A regular expression parameter is missing or invalid.
Reason for the Error
The FUNCTION_TYPE was DBMS_REDACT.REGEXP, but one or more of the regular expression parameters were missing or invalid, the REGEXP_PATTERN failed to compile properly, or the regular expression replacement operation failed.
Solution
Specify the regular expression parameters according to Oracle documentation. At a minimum, the REGEXP_PATTERN and the REGEXP_REPLACE_STRING must be specified. Ensure that the REGEXP_PATTERN can compile properly as a regular expression, for example by testing it with REGEXP_REPLACE in a SQL query against a column containing some of the data to be redacted.
