OCI-28078
A regular expression parameter is missing or invalid.
Cause
Even though the function_type was DBMS_REDACT.REGEXP, the possible causes for this error include:
- One or more of the regular expression parameters were missing or invalid.
- The REGEXP_PATTERN failed to compile properly.
- The regular expression replacement operation failed.
Action
Specify the regular expression parameters according to Oracle Database documentation. At a minimum, specify the REGEXP_PATTERN and REGEXP_REPLACE_STRING parameters. Ensure that the REGEXP_PATTERN can compile properly as a regular expression. For example, test it with REGEXP_REPLACE in a SQL query against a column containing some of the data to be redacted.
OCI-28078
A regular expression parameter is missing or invalid.
Cause
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.
Action
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.
OCI-28078
A regular expression parameter is missing or invalid.
Cause
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.
Action
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.