Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trouble calling dbms_obfuscation_toolkit.desdecrypt

Trouble calling dbms_obfuscation_toolkit.desdecrypt

From: Haber Schabernackel <schabernackel_at_hotmail.com>
Date: Thu, 01 Nov 2001 18:08:47 GMT
Message-ID: <1103_1004638127@f3bpc14>

I'm trying to:

create or replace
  function decrypt (p_str in varchar2, p_key in varchar2) return varchar2   is
    str varchar2(16);
  begin
    dbms_obfuscation_toolkit.desdecrypt(p_str,p_key,str);     return str;
  end;
/

sho err

LINE/COL ERROR

-------- -----------------------------------------------------------------
5/5      PLS-00307:  too many declarations of 'DESDECRYPT' match this call
5/5      PL/SQL: Statement ignored


What am I doing wrong?

(Yes, I know there are two versions of desdecrypt(), one raw and one varchar2 version. But that can't be the problem here?).

HS Received on Thu Nov 01 2001 - 12:08:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US