 |
|
Oracle Tips by Burleson |
Chapter 6 Oracle Encryption
Table 6.3 Parameters for DES3Encrypt Function for
RAW
As in case of the procedure, the function also
has a counterpart using parameters in VARCHAR2 datatype.
Since the code DES3Encrypt is defined as both a
function and a procedure, as well as overloaded with several types
of parameters, there are actually four declarations for the code
segment. Therefore, the calling of this code segment with parameters
may not work without naming the parameters. You have to use named
parameters, as described in the example in the beginning of the
chapter.
DES3Decrypt
Similar to the encryption routines, the package
also has decryption routines – and there are four declarations to
it, just like its encryption counterpart. Here is the explanation of
the procedure version using RAW datatypes.
|
PARAMETER |
DESCRIPTION |
|
INPUT |
This is the input value to be decrypted
in RAW datatype. |
|
KEY |
This is the encryption key in the RAW
datatype. |
|
DECRYPTED_DATA |
This is the only OUT parameter of the
procedure, again in RAW datatype. This returns the decrypted
raw data. |
The above text is
an excerpt from:
Oracle Privacy Security Auditing
The
Final Word on Oracle Security
This is the only authoritative
book on Oracle Security, Oracle Privacy, and Oracle Auditing written
by two of the world’s leading Oracle Security experts.
This indispensable book is only $39.95 and has an
immediate download of working security scripts:
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
