| |
 |
|
Oracle Tips by Burleson |
Chapter 6 Oracle Encryption
|
PARAMETER |
DESCRIPTION |
|
KEY |
This is the encryption key in the RAW
datatype. |
|
WHICH |
0 – for double pass and 1 – for triple
pass. |
|
ENCRYPTED_DATA |
This is the only OUT parameter of the
procedure, again in RAW datatype. |
|
IV |
The same as the explanation for IV_STRING
in the string version of the procedure, but in RAW datatype. |
Table 6.2 Parameters for DES3Encrypt Procedure
for RAW
Here is the function version of the same code
using raw data as parameters. This function returns the encrypted
value in RAW datatype.
|
PARAMETER |
DESCRIPTION |
|
INPUT |
This is the input value to be encrypted
in RAW datatype. |
|
KEY |
This is the encryption key in the RAW
datatype. |
|
WHICH |
0 – for double pass and 1 – for triple
pass. 0 is the default. |
|
IV |
The same as the explanation for
IV_STRING in the string version of the procedure, but in RAW
datatype. Default is null. |
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
|
|