Re: i have resolved it

DA Morgan schreef:
> Steve Howard wrote:

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

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...