Oracle | DBMS_REDACTOR

Oracle DBMS_REDACTOR Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Data Redaction support

AUTHID DEFINER

Dependencies

DBMS_REDACTOR_LIB

Documented No

First Available 23ai

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

Source {ORACLE_HOME}/rdbms/admin/prvtredact.plb

Subprograms

REDACT

REDACT (new 23ai)

Returns the redaction pattern consisting of non string and numeric characters dbms_redactor.redact( instring IN VARCHAR2, outstring OUT VARCHAR2, hints_are_comment IN BOOLEAN, only_length IN BOOLEAN, character_set IN BOOLEAN) RETURN BINARY_INTEGER;

DECLARE

 outVal dbms_id;

 retVal BINARY_INTEGER;

      BEGIN

  retVal := dbms_redactor.redact('4567-1234-5678-9012', 
      outVal, TRUE, TRUE, TRUE);

  dbms_output.put_line(outVal);

  dbms_output.put_line(retVal);

      END;

      /

      (*) *-*

      6

      

      DECLARE

 outVal dbms_id;

 retVal BINARY_INTEGER;

      BEGIN

  retVal := dbms_redactor.redact('4567-1234-5678-9012', 
      outVal, TRUE, TRUE, TRUE);

  dbms_output.put_line(outVal);

  dbms_output.put_line(retVal);

      END;

      /

      *-*-*-*

      7

      

      PL/SQL procedure successfully completed.

      DECLARE

 outVal dbms_id;

 retVal BINARY_INTEGER;

      BEGIN

  retVal := dbms_redactor.redact('4567-1234-5678-9012', 
      outVal, TRUE, TRUE, TRUE);

  dbms_output.put_line(outVal);

  dbms_output.put_line(retVal);

      END;

      /

      7

      

      PL/SQL procedure successfully completed.