Encryption and Decryption [message #191183] |
Tue, 05 September 2006 02:18 |
ramzi_j_h
Messages: 36 Registered: September 2006 Location: Jordan
|
Member |
|
|
Hi ... and thanx alot 4 ur cooperation in advance ...
i'm using
developer 6i
Database SQL Plus 9i
i have a table includes
student_number NOT NULL NUMBER(10)
student_password VARCHAR2(10)
as the student_number field is the username for the student,
however, when the user type his password i want to encrypt this password into the database , so
that when i log into SQL Plus i do not see the same password (encrypted or digested)
and also when i make the validation on the password when retrieving the password from the
database i want to make the decryption ...
really i read about the DBMS_OBFUSCATION_TOOLKIT
but i'm asking , is it used at the FORM LEVEL ? or DATABASE LEVEL ?
and how is it used ?
Best regards
|
|
|
|
Re: Encryption and Decryption [message #191205 is a reply to message #191183] |
Tue, 05 September 2006 03:17 |
ramzi_j_h
Messages: 36 Registered: September 2006 Location: Jordan
|
Member |
|
|
it stays giving me this error while decryption !!!
ORA-28232 Invalid input size for Obfuscation toolkit
Cause: Input to DES encryption/decryption routine not a multiple of 8 bytes.
Action: Make sure that the input corresponding to the PL/SQL function is a multiple of 8 bytes.
|
|
|