Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck
 

 

   
 

DBMS_CRYPTO_TOOLKIT package tips

Oracle Tips by Burleson Consulting

DBMS_CRYPTO_TOOLKIT

<< Return to the index

Related notes on DBMS_CRYPTO_TOOLKIT:


Oracle 11g provides the following information about the DBMS_CRYPTO_TOOLKIT package:

Description of the DBMS_CRYPTO_TOOLKIT package:



PROCEDURE DBMS_CRYPTO_TOOLKIT.ABORTIDENTITY
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 IDENTITY                       RECORD                  IN/OUT
   DESCRIPTOR                   RAW(200)                IN/OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.CLOSEPERSONA
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN/OUT
   PERSONA                      RAW(200)                IN/OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.CLOSEWALLET
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 WALLET                         RECORD                  IN/OUT
   WALLET                       RAW(200)                IN/OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.CLOSEWALLET

PROCEDURE DBMS_CRYPTO_TOOLKIT.CREATEIDENTITY
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 IDENTITYTYPE                   BINARY_INTEGER          IN
 PUBLIC_IDENTITY                VARCHAR2                IN
 ALIAS                          VARCHAR2                IN
 LONGER_DESCRIPTION             VARCHAR2                IN
 TRUST_QUALIFIER                VARCHAR2                IN
 IDENTITY                       RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.CREATEPERSONA
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 CIPHER_TYPE                    BINARY_INTEGER          IN
 PRIVATE_INFORMATION            RECORD                  IN
   INFORMATION                  RAW(200)                IN
 PRL                            VARCHAR2                IN
 ALIAS                          VARCHAR2                IN
 LONGER_DESCRIPTION             VARCHAR2                IN
 PERSONA                        RECORD                  OUT
   PERSONA                      RAW(200)                OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.CREATEWALLET
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PASSWORD                       VARCHAR2                IN
 WALLET                         RECORD                  IN/OUT
   WALLET                       RAW(200)                IN/OUT
 WALLET_RESOURCE_LOCATOR        VARCHAR2                IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.CREATEWALLET
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PASSWORD                       VARCHAR2                IN
 WALLET_RESOURCE_LOCATOR        VARCHAR2                IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.DECRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 ENCRYPTED_DATA                 RAW                     IN
 DECRYPTED_DATA                 RAW                     OUT
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.DECRYPT RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 ENCRYPTED_DATA                 RAW                     IN
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.DECRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 ENCRYPTED_STRING               VARCHAR2                IN
 DECRYPTED_STRING               VARCHAR2                OUT
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.DECRYPT RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 ENCRYPTED_STRING               VARCHAR2                IN
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.DEENVELOPE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 ENVELOPED_DATA                 RAW                     IN
 OUTPUT_DATA                    RAW                     OUT
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SENDER_IDENTITY                RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.DEENVELOPE RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 ENVELOPED_DATA                 RAW                     IN
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SENDER_IDENTITY                RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.DEENVELOPE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 ENVELOPED_STRING               VARCHAR2                IN
 OUTPUT_STRING                  VARCHAR2                OUT
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SENDER_IDENTITY                RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.DEENVELOPE RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 ENVELOPED_STRING               VARCHAR2                IN
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SENDER_IDENTITY                RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.DESTROYWALLET
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PASSWORD                       VARCHAR2                IN
 WALLET_RESOURCE_LOCATOR        VARCHAR2                IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.ENCRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 ENCRYPTED_DATA                 RAW                     OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.ENCRYPT RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.ENCRYPT RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.ENVELOPE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RECIPIENT                      RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN
 INPUT                          RAW                     IN
 ENVELOPED_DATA                 RAW                     OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.ENVELOPE RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RECIPIENT                      RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN
 INPUT                          RAW                     IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.ENVELOPE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RECIPIENT                      RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENVELOPED_STRING               VARCHAR2                OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.ENVELOPE RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RECIPIENT                      RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.ENVELOPE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_RECIPIENTS           BINARY_INTEGER          IN
 RECIPIENT_LIST                 RECORD                  IN
   DESCRIPTOR_ARRAY             RAW(200)                IN
 INPUT                          RAW                     IN
 ENVELOPED_DATA                 RAW                     OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.ENVELOPE RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_RECIPIENTS           BINARY_INTEGER          IN
 RECIPIENT_LIST                 RECORD                  IN
   DESCRIPTOR_ARRAY             RAW(200)                IN
 INPUT                          RAW                     IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.ENVELOPE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_RECIPIENTS           BINARY_INTEGER          IN
 RECIPIENT_LIST                 RECORD                  IN
   DESCRIPTOR_ARRAY             RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENVELOPED_STRING               VARCHAR2                OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.ENVELOPE RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_RECIPIENTS           BINARY_INTEGER          IN
 RECIPIENT_LIST                 RECORD                  IN
   DESCRIPTOR_ARRAY             RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.HASH
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 HASH                           RAW                     OUT
 HASH_STATE                     BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.HASH RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 HASH_STATE                     BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.HASH
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 HASH                           RAW                     OUT
 HASH_STATE                     BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.HASH RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 HASH_STATE                     BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.INITIALIZE

PROCEDURE DBMS_CRYPTO_TOOLKIT.KEYEDHASH
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 KEYED_HASH                     RAW                     OUT
 HASH_STATE                     BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.KEYEDHASH RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 HASH_STATE                     BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.KEYEDHASH
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 KEYED_HASH                     RAW                     OUT
 HASH_STATE                     BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.KEYEDHASH RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 HASH_STATE                     BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.OPENPERSONA
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN/OUT
   PERSONA                      RAW(200)                IN/OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.OPENWALLET
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PASSWORD                       VARCHAR2                IN
 WALLET                         RECORD                  IN/OUT
   WALLET                       RAW(200)                IN/OUT
 PERSONA_LIST                   TABLE OF RECORD         OUT
 WALLET_RESOURCE_LOCATOR        VARCHAR2                IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.OPENWALLET
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PASSWORD                       VARCHAR2                IN
 PERSONA_LIST                   TABLE OF RECORD         OUT
 WALLET_RESOURCE_LOCATOR        VARCHAR2                IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.PKDECRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 DECRYPTED_DATA                 RAW                     OUT
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.PKDECRYPT RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.PKDECRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 DECRYPTED_STRING               VARCHAR2                OUT
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.PKDECRYPT RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 DECRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.PKENCRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RECIPIENT                      RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN
 INPUT                          RAW                     IN
 ENCRYPTED_DATA                 RAW                     OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.PKENCRYPT RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RECIPIENT                      RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN
 INPUT                          RAW                     IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.PKENCRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RECIPIENT                      RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENCRYPTED_STRING               VARCHAR2                OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.PKENCRYPT RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RECIPIENT                      RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.PKENCRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_RECIPIENTS           BINARY_INTEGER          IN
 RECIPIENT_LIST                 RECORD                  IN
   DESCRIPTOR_ARRAY             RAW(200)                IN
 INPUT                          RAW                     IN
 ENCRYPTED_DATA                 RAW                     OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.PKENCRYPT RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_RECIPIENTS           BINARY_INTEGER          IN
 RECIPIENT_LIST                 RECORD                  IN
   DESCRIPTOR_ARRAY             RAW(200)                IN
 INPUT                          RAW                     IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.PKENCRYPT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_RECIPIENTS           BINARY_INTEGER          IN
 RECIPIENT_LIST                 RECORD                  IN
   DESCRIPTOR_ARRAY             RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENCRYPTED_STRING               VARCHAR2                OUT
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.PKENCRYPT RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_RECIPIENTS           BINARY_INTEGER          IN
 RECIPIENT_LIST                 RECORD                  IN
   DESCRIPTOR_ARRAY             RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 ENCRYPTION_STATE               BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.RANDOMBYTES
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_BYTES_DESIRED        BINARY_INTEGER          IN
 RANDOM_BYTES                   RAW                     OUT

FUNCTION DBMS_CRYPTO_TOOLKIT.RANDOMBYTES RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 NUMBER_OF_BYTES_DESIRED        BINARY_INTEGER          IN

PROCEDURE DBMS_CRYPTO_TOOLKIT.RANDOMNUMBER
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 RANDOM_NUMBER                  BINARY_INTEGER          OUT

FUNCTION DBMS_CRYPTO_TOOLKIT.RANDOMNUMBER RETURNS BINARY_INTEGER
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN

PROCEDURE DBMS_CRYPTO_TOOLKIT.REMOVEIDENTITY
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 IDENTITY                       RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.REMOVEPERSONA
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN/OUT
   PERSONA                      RAW(200)                IN/OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.SEEDRANDOM
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 SEED                           RAW                     IN

PROCEDURE DBMS_CRYPTO_TOOLKIT.SEEDRANDOM
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 SEED                           VARCHAR2                IN

PROCEDURE DBMS_CRYPTO_TOOLKIT.SEEDRANDOM
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 SEED                           BINARY_INTEGER          IN

PROCEDURE DBMS_CRYPTO_TOOLKIT.SIGN
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 SIGNATURE                      RAW                     OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.SIGN RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.SIGN
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 SIGNATURE                      RAW                     OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.SIGN RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.SIGNDETACHED
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 SIGNATURE                      RAW                     OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.SIGNDETACHED RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT                          RAW                     IN
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.SIGNDETACHED
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 SIGNATURE                      RAW                     OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.SIGNDETACHED RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 INPUT_STRING                   VARCHAR2                IN
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.STOREPERSONA
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN/OUT
   PERSONA                      RAW(200)                IN/OUT
 WALLET                         RECORD                  IN/OUT
   WALLET                       RAW(200)                IN/OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.STOREPERSONA
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN/OUT
   PERSONA                      RAW(200)                IN/OUT

PROCEDURE DBMS_CRYPTO_TOOLKIT.STORETRUSTEDIDENTITY
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 IDENTITY                       RECORD                  IN/OUT
   DESCRIPTOR                   RAW(200)                IN/OUT
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN

PROCEDURE DBMS_CRYPTO_TOOLKIT.TERMINATE

FUNCTION DBMS_CRYPTO_TOOLKIT.VALIDATE RETURNS BOOLEAN
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 IDENTITY                       RECORD                  IN
   DESCRIPTOR                   RAW(200)                IN

PROCEDURE DBMS_CRYPTO_TOOLKIT.VERIFY
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 SIGNATURE                      RAW                     IN
 EXTRACTED_MESSAGE              RAW                     OUT
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SIGNING_PARTY_IDENTITY         RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.VERIFY RETURNS RAW
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 SIGNATURE                      RAW                     IN
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SIGNING_PARTY_IDENTITY         RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.VERIFY
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 SIGNATURE                      RAW                     IN
 EXTRACTED_MESSAGE_STRING       VARCHAR2                OUT
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SIGNING_PARTY_IDENTITY         RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

FUNCTION DBMS_CRYPTO_TOOLKIT.VERIFY RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 SIGNATURE                      RAW                     IN
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SIGNING_PARTY_IDENTITY         RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.VERIFYDETACHED
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 DATA                           RAW                     IN
 SIGNATURE                      RAW                     IN
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SIGNING_PARTY_IDENTITY         RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

PROCEDURE DBMS_CRYPTO_TOOLKIT.VERIFYDETACHED
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 PERSONA                        RECORD                  IN
   PERSONA                      RAW(200)                IN
 DATA_STRING                    VARCHAR2                IN
 SIGNATURE                      RAW                     IN
 VERIFIED                       BOOLEAN                 OUT
 VALIDATED                      BOOLEAN                 OUT
 SIGNING_PARTY_IDENTITY         RECORD                  OUT
   DESCRIPTOR                   RAW(200)                OUT
 SIGNATURE_STATE                BINARY_INTEGER          IN     DEFAULT

   

 
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

 

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.