 |
|
DBMS_OBFUSCATION_TOOLKIT package tips
Oracle Tips by Burleson Consulting |
DBMS_OBFUSCATION_TOOLKIT
<< Return to the index
Related notes on DBMS_OBFUSCATION_TOOLKIT:
Oracle 11g provides the following information about the DBMS_OBFUSCATION_TOOLKIT package:
Description of the DBMS_OBFUSCATION_TOOLKIT package:
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DES3DECRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
KEY RAW IN
DECRYPTED_DATA RAW OUT
WHICH BINARY_INTEGER IN DEFAULT
IV RAW IN DEFAULT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DES3DECRYPT RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
KEY RAW IN
WHICH BINARY_INTEGER IN DEFAULT
IV RAW IN DEFAULT
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DES3DECRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
KEY_STRING VARCHAR2 IN
DECRYPTED_STRING VARCHAR2 OUT
WHICH BINARY_INTEGER IN DEFAULT
IV_STRING VARCHAR2 IN DEFAULT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DES3DECRYPT RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
KEY_STRING VARCHAR2 IN
WHICH BINARY_INTEGER IN DEFAULT
IV_STRING VARCHAR2 IN DEFAULT
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DES3ENCRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
KEY RAW IN
ENCRYPTED_DATA RAW OUT
WHICH BINARY_INTEGER IN DEFAULT
IV RAW IN DEFAULT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DES3ENCRYPT RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
KEY RAW IN
WHICH BINARY_INTEGER IN DEFAULT
IV RAW IN DEFAULT
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DES3ENCRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
KEY_STRING VARCHAR2 IN
ENCRYPTED_STRING VARCHAR2 OUT
WHICH BINARY_INTEGER IN DEFAULT
IV_STRING VARCHAR2 IN DEFAULT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DES3ENCRYPT RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
KEY_STRING VARCHAR2 IN
WHICH BINARY_INTEGER IN DEFAULT
IV_STRING VARCHAR2 IN DEFAULT
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DES3GETKEY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
WHICH BINARY_INTEGER IN DEFAULT
SEED RAW IN
KEY RAW OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DES3GETKEY RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
WHICH BINARY_INTEGER IN DEFAULT
SEED RAW IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DES3GETKEY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
WHICH BINARY_INTEGER IN DEFAULT
SEED_STRING VARCHAR2 IN
KEY VARCHAR2 OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DES3GETKEY RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
WHICH BINARY_INTEGER IN DEFAULT
SEED_STRING VARCHAR2 IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
KEY RAW IN
DECRYPTED_DATA RAW OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
KEY RAW IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
KEY_STRING VARCHAR2 IN
DECRYPTED_STRING VARCHAR2 OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
KEY_STRING VARCHAR2 IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
KEY RAW IN
ENCRYPTED_DATA RAW OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
KEY RAW IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
KEY_STRING VARCHAR2 IN
ENCRYPTED_STRING VARCHAR2 OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
KEY_STRING VARCHAR2 IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DESGETKEY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SEED RAW IN
KEY RAW OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DESGETKEY RETURNS RAW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SEED RAW IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.DESGETKEY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SEED_STRING VARCHAR2 IN
KEY VARCHAR2 OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.DESGETKEY RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SEED_STRING VARCHAR2 IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.MD5
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
CHECKSUM RAW(16) OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.MD5 RETURNS RAW(16)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT RAW IN
PROCEDURE DBMS_OBFUSCATION_TOOLKIT.MD5
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
CHECKSUM_STRING VARCHAR2(16) OUT
FUNCTION DBMS_OBFUSCATION_TOOLKIT.MD5 RETURNS VARCHAR2(16)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
INPUT_STRING VARCHAR2 IN
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
