When creating a new Data source in Data-manager , once you select a Data Source Type
You receive the following error :
An error occured while processing your request.
A database error occured while processing your request. Please try again..
java.sql.SQLSyntaxErrorException: ORA-00904: "DBMS_LOB"."COMPARE": invalid identifier
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];