Hai
I made a form to encrypt and decrypt text string (more than 4000 Chr long).I had create function when executing the function getting the below error message.Any one any idea about this it should be greatful
Thanks in advance
mohan
create or replace function crypt( p_str in varchar2 )
return varchar2
as
l_data varchar2(255);
begin
l_data := rpad( p_str, (trunc(length(p_str)/8)+1)*8, chr(0) );
dbms_obfuscation_toolkit.DESEncrypt
( input_string => l_data,
key_string => 'MagicKey',
encrypted_string=> l_data );
return UTL_RAW.CAST_TO_RAW( l_data );
end;
Function created
SQL> select crypt( '012345678 ') from dual;
select crypt( '012345678 ') from dual
*
ERROR at line 1:
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYSTEM.DBMS_OBFUSCATION_TOOLKIT_FFI", line 0
ORA-06512: at "SYSTEM.DBMS_OBFUSCATION_TOOLKIT", line 24
ORA-06512: at "SYSTEM.CRYPT", line 7
ORA-06512: at line 1