Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data encryption
Hi Niall
'Ve the error:
ORA-28232: invalid input length for obfuscation toolkit ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 0 ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 33 ORA-06512: at line 8
set serveroutput on;
declare
a varchar2(2000);
b varchar2(2000);
s varchar2(2000);
begin
a := 'azerty';
b := 'abc';
DBMS_OBFUSCATION_TOOLKIT.DESEncrypt(input_string => a, key_string => b, encrypted_string => s);
dbms_output.put_line(s);
end;
Bests regards
Epicentre
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3cd14614$0$230$ed9e5944_at_reading.news.pipex.net...
> Yes. You can either call your favaourite encryption routine via an
external
> procedure call or use DBMS_OBFUSCATION_TOOLKIT supplied procedure which
can
> use DES (or triple DES which I think is new in 9i).
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Epicentre Team A ANNECY" <djeanneret_at_epicentre.fr> wrote in message
> news:aarcde$n0m$1_at_wanadoo.fr...
> > Hi
> >
> > Is possible to do a data encryption in Oracle ?
> >
> > Bests regards
> > Epicentre
> >
> >
>
>
Received on Tue May 07 2002 - 04:00:03 CDT