Search notes:
ORA-01465: invalid hex number
The first insert statement will succeed, the second throws ORA-01465: invalid hex number:
create table tq84_ora_01465 (b blob);
insert into tq84_ora_01465 values ('abcdef');
insert into tq84_ora_01465 values ('abcdefgh');
Similarly, this error is also thrown when a PL/SQL function parameter is declared as RAW and a non-hexadecimal value is passed:
select utl_encode.base64_decode('abcdefgh') from dual;
select utl_encode.base64_encode('abcdefgh') from dual;