Oracle DBMS_CRYPTO_INTERNAL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
ALL_APPLY_CONFLICT_COLUMNS DBA_TAB_COLS_V$ KU$_TAB_ONLY_STATS_VIEW
ALL_APPLY_KEY_COLUMNS DBA_TAB_COLUMNS USER_COL_PENDING_STATS
ALL_APPLY_TABLE_COLUMNS DBA_TAB_COL_STATISTICS USER_NESTED_TABLE_COLS
ALL_COL_PENDING_STATS DBA_TAB_HISTGRM_PENDING_STATS USER_PART_COL_STATISTICS
ALL_NESTED_TABLE_COLS DBA_TAB_HISTOGRAMS USER_PART_HISTOGRAMS
ALL_PART_COL_STATISTICS DBA_TSTZ_TABLES USER_PUBLISHED_COLUMNS
ALL_PART_HISTOGRAMS DBA_TSTZ_TAB_COLS USER_SUBPART_COL_STATISTICS
ALL_SUBPART_COL_STATISTICS EXU10ASC USER_SUBPART_HISTOGRAMS
ALL_SUBPART_HISTOGRAMS EXU10ASCU USER_TAB_COLS
ALL_TAB_COLS EXU8ASC USER_TAB_COLS_V$
ALL_TAB_COLS_V$ EXU8ASCU USER_TAB_COLUMNS
ALL_TAB_COLUMNS EXU8HST USER_TAB_COL_STATISTICS
ALL_TAB_COL_STATISTICS EXU8HSTU USER_TAB_HISTGRM_PENDING_STATS
ALL_TAB_HISTGRM_PENDING_STATS KU$_10_1_HISTGRM_MAX_VIEW USER_TAB_HISTOGRAMS
ALL_TAB_HISTOGRAMS KU$_10_1_HISTGRM_MIN_VIEW USER_TSTZ_TABLES
CRYPTO_INTERNAL_LIB KU$_10_1_PTAB_COL_STATS_VIEW USER_TSTZ_TAB_COLS
DBA_COL_PENDING_STATS KU$_10_1_PTAB_STATS_VIEW WM$COLUMN_PROPS
DBA_LOGSTDBY_EDS_SUPPORTED KU$_10_1_TAB_COL_STATS_VIEW WM$DBA_TAB_COLS
DBA_NESTED_TABLE_COLS KU$_10_1_TAB_ONLY_STATS_VIEW WM_COMPRESS_BATCH_SIZES
DBA_PART_COL_STATISTICS KU$_10_1_TAB_STATS_VIEW _HISTGRM_DEC
DBA_PART_HISTOGRAMS KU$_10_2_TAB_STATS_VIEW _HIST_HEAD_DEC
DBA_PUBLISHED_COLUMNS KU$_11_2_TAB_STATS_VIEW _OPTSTAT_HISTGRM_HISTORY_DEC
DBA_SUBPART_COL_STATISTICS KU$_COL_STATS_VIEW _OPTSTAT_HISTHEAD_HISTORY_DEC
DBA_SUBPART_HISTOGRAMS KU$_HISTGRM_VIEW _user_stat
DBA_TAB_COLS KU$_PTAB_STATS_VIEW _user_stat_varray
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvtcia.plb
Subprograms
 
STATSDECRYPTNUM (new 12.2)
Undocumented dbms_crypto_internal.statsDecryptNum(
obj_nbr       IN NUMBER,
col_nbr       IN NUMBER,
encrypted_num IN NUMBER)
RETURN NUMBER;
DECLARE
 objNum        sys.wri$_optstat_histhead_history.obj#%TYPE := 8476;
 intCol        sys.wri$_optstat_histhead_history.intcol#%TYPE := 1;
 encryptMinVal sys.wri$_optstat_histhead_history.minimum_enc := 2199;
BEGIN
  dbms_crypto_internal.statsDecryptNum(obj#, intcol#, minimum_enc);
END;
/
 
STATSDECRYPTRAW (new 12.2)
Undocumented dbms_crypto_internal.statsDecryptRaw(
obj_nbr    IN NUMBER,
col_nbr    IN NUMBER,
ciphertext IN RAW)
RETURN RAW;
exec dbms_crypto_internal.statsDecryptRaw( obj#, intcol#, lowval);
 
STATSENCRYPTNUM (new 12.2)
Undocumented dbms_crypto_internal.statsEncryptNum(
obj_nbr      IN NUMBER,
col_nbr      IN NUMBER,
num_in_clear IN NUMBER)
RETURN RAW;
TBD
 
STATSENCRYPTRAW (new 12.2)
Undocumented dbms_crypto_internal.statsEncryptRaw(
obj_nbr    IN NUMBER,
col_nbr    IN NUMBER,
cleartext  IN RAW)
RETURN RAW;
TBD
 
UPDATESENSITIVESTATS (new 12.2)
Undocumented dbms_crypto_internal.updateSensitiveStats;
exec dbms_crypto_internal.updateSensitiveStats;

Related Topics
DBMS_CRYPTO
DBMS_CRYPTO_FFI
DBMS_CRYPTO_TOOLKIT
DBMS_CRYPTO_TOOLKIT_TYPES
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved