Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_obfuscation_toolkit (hex to raw conversion error)

jp609096Dec 10 2008 — edited Dec 10 2008
hai 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2009
Added on Dec 10 2008
15 comments
1,042 views