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: i have resolved it

Re: i have resolved it

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 29 Dec 2006 23:25:17 +0100
Message-ID: <en2q8n$reu$1@news6.zwoll1.ov.home.nl>


DA Morgan schreef:
> Steve Howard wrote:

>> yongjia wrote:
>>> i have resolved it
>>>
>>> lenghtb
>>
>> Good job!  Wait, what were you working on again?...
>>

>
> A problem working with Japanese and Chinese and the Obfuscation toolkit.
>
> Yongjia ... what was the solution?

Other post, basically, this (because of the encryption only working on byte boundaries):
v_text := rpad( orgstr, (trunc(length(orgstr)/8)+1)*8, chr(0));

if orgstr is null then

   return null;
end if;

dbms_obfuscation_toolkit.desencrypt(
input_string => v_text,
key_string => keystr,
encrypted_string => encstr
);

Should be this:
v_text := rpad( orgstr, (trunc(lengthb(orgstr)/8)+1)*8, chr(0)); <<<<<

if orgstr is null then

   return null;
end if;

dbms_obfuscation_toolkit.desencrypt(
input_string => v_text,
key_string => keystr,
encrypted_string => encstr
);

The original post was called "encrypt Chinese or Japanese"

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Fri Dec 29 2006 - 16:25:17 CST

Original text of this message

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