Hi All,
While running below plsql block we are getting the below error ,why because string contains apostrophe symbol.
declare
l_value VARCHAR2(1000) := 'A’bcd';
l_raw RAW(2000);
BEGIN
DBMS_OUTPUT.put_line('l_value: ' || l_value);
--l_value := utl_raw.cast_to_varchar2(l_value);
DBMS_OUTPUT.put_line('l_value1: ' || l_value);
l_raw := toolkit.encrypt(l_value);
DBMS_OUTPUT.put_line('l_raw: ' || l_raw);
DBMS_OUTPUT.put_line('Original Value : ' || toolkit.decrypt(l_raw));
END;
/
Error:
ORA-28232: invalid input length for obfuscation toolkit
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 21
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 99
ORA-06512: at "LH_DWE.TOOLKIT", line 17
28232. 0000 - "invalid input length for obfuscation toolkit"