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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.