The database user used by data manager to connect to the oracle database does not have the right permissions
The ORA-00904 error in conjunction with dbms_lob indicates that the execute privilege has not been granted to "PUBLIC" or has been revoked.
The execute priv on dbms_lob needs to be granted to PUBLIC or the individual user.
Log into SQLPlus as sys as sysdba:
SQL> grant execute on dbms_lob to Public;
SQL> grant execute on dbms_lob to [database user];