ORA-00904: invalid identifier.
For example:
SELECT dbms_lob.getlength(networkoriginalmessage) blob_len *ERROR at line 58:
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;
or
SQL> grant execute on dbms_lob to [user];