create or replace function DESencryptForMdn(
p_input_string varchar2,
p_key_string varchar2) return varchar2 is
Result varchar2(32) ;
v_newstring varchar2(60);
raw_input RAW(128) := UTL_RAW.CAST_TO_RAW(p_input_string);
raw_key RAW(128) := UTL_RAW.CAST_TO_RAW(p_key_string);
encrypted_raw RAW(2048);
error_in_input_buffer_length EXCEPTION;
double_encrypt_not_permitted EXCEPTION;
begin
dbms_obfuscation_toolkit.DESEncrypt(input => raw_input,
key => raw_key, encrypted_data => encrypted_raw );
v_newstring := rawtohex(encrypted_raw);
insert into TEST_TABLE values (encrypted_raw) ;
dbms_output.put_line('加密后的字符串:' ||v_newstring );
result :=v_newstring;
return(Result);
end DESencryptForMdn;
p_input_string varchar2,
p_key_string varchar2) return varchar2 is
Result varchar2(32) ;
v_newstring varchar2(60);
raw_input RAW(128) := UTL_RAW.CAST_TO_RAW(p_input_string);
raw_key RAW(128) := UTL_RAW.CAST_TO_RAW(p_key_string);
encrypted_raw RAW(2048);
error_in_input_buffer_length EXCEPTION;
double_encrypt_not_permitted EXCEPTION;
begin
dbms_obfuscation_toolkit.DESEncrypt(input => raw_input,
key => raw_key, encrypted_data => encrypted_raw );
v_newstring := rawtohex(encrypted_raw);
insert into TEST_TABLE values (encrypted_raw) ;
dbms_output.put_line('加密后的字符串:' ||v_newstring );
result :=v_newstring;
return(Result);
end DESencryptForMdn;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货