Error
Error Code:
ORA-28092
Oracle Error ORA-28092: Invalid Parameter Value
Description
The ORA-28092 error indicates an issue with a parameter value used in a Data Redaction procedure call (DBMS_REDACT). This typically happens when creating, dropping, or applying policy expressions with invalid or conflicting names, or when applying policies to unsupported objects.
Error Message
ORA-28092: The parameter string with value ' string ' has an error.
Known Causes
4 known causesDuplicate Policy Expression Name
Attempting to create a new redaction policy expression with a name that already exists will trigger this error.
Invalid Policy Expression Name
The policy expression name provided during creation or modification is invalid (e.g., contains special characters or exceeds the maximum length).
Policy Expression Still in Use
Trying to drop a policy expression that is currently associated with a column will result in this error.
Unsupported Object Type
Applying a Data Redaction policy to an object type that is not supported (e.g., metadata-linked views, OLAP analytic workspaces, or objects within APEX, Sharding or Spatial installation schemas) will cause this error.
Solutions
Coming SoonGeneral Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service