dbms_obfuscation_toolkit (hex to raw conversion error)
jp609096Dec 10 2008 — edited Dec 10 2008hai everybody,
i created a pl/sql procedure to encrypt the data based on dbms_obfuscation_toolkit package..and when i run the procedure i stuck with this error..
ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
this is my procedure..
create or replace procedure proc_test_encrypt_data
(
text varchar2:='john'
)
is
raw_key raw(3789) :=utl_raw.cast_to_varchar2('text');
en_data raw(3789);
begin
dbms_obfuscation_toolkit.DESEncrypt(input =>text,key => raw_key,encrypted_data =>en_data);
dbms_output.put_line(utl_raw.cast_to_varchar2(en_data));
end;
help needed...
jp@valapad