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 -> Re: Data encryption

Re: Data encryption

From: Epicentre Team A ANNECY <djeanneret_at_epicentre.fr>
Date: Tue, 7 May 2002 11:00:03 +0200
Message-ID: <ab84ka$bbi$1@wanadoo.fr>


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

Original text of this message

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