Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trouble calling dbms_obfuscation_toolkit.desdecrypt
try that way:
create or replace
function decrypt (p_str in varchar2, p_key in varchar2) return varchar2
is
str varchar2(16);
begin
sys.dbms_obfuscation_toolkit.desdecrypt(input_string => p_str,
key_string => p_key,
decrypted_string => str);
return str;
end;
/
Received on Mon Nov 05 2001 - 05:48:05 CST