DBMS_CRYPTO decypt problems
Hi All,
I am trying to implement some level of encryption on our
application. I am going to use the DBMS_CRYPTO package for it.
I use the following script for testing
DECLARE
P_AGE VARCHAR2(30 BYTE):='42';
P_RAW_AGE RAW(4096);
P_EAGE VARCHAR2(30 BYTE);
v_key_str nvarchar2(16):='qwertyuiasdfghjk';
v_raw_key raw(16);
BEGIN
-- encrypt
P_RAW_AGE:=UTL_I18N.STRING_TO_RAW (P_AGE, 'AL32UTF8');
v_raw_key:=UTL_I18N.STRING_TO_RAW ('qwertyuiasdfghjk', 'AL32UTF8');
DBMS_OUTPUT.PUT_LINE('Key length : '||UTL_RAW.LENGTH(v_raw_key) );
P_RAW_AGE:=DBMS_CRYPTO.ENCRYPT(
I use the following script for testing
DECLARE
P_AGE VARCHAR2(30 BYTE):='42';
P_RAW_AGE RAW(4096);
P_EAGE VARCHAR2(30 BYTE);
v_key_str nvarchar2(16):='qwertyuiasdfghjk';
v_raw_key raw(16);
BEGIN
-- encrypt
P_RAW_AGE:=UTL_I18N.STRING_TO_RAW (P_AGE, 'AL32UTF8');
v_raw_key:=UTL_I18N.STRING_TO_RAW ('qwertyuiasdfghjk', 'AL32UTF8');
DBMS_OUTPUT.PUT_LINE('Key length : '||UTL_RAW.LENGTH(v_raw_key) );
P_RAW_AGE:=DBMS_CRYPTO.ENCRYPT(
0