Getting "The requested database object information has not been retrieved" when trying to view DDL for an object (4302123)

When I try to view the script for an Oracle View, I get the following message:

"The requested database object information has not been retrieved. Object information is retrieved by SYS.DBMS_METADATA. Check to see that you have privileges for this package."

RESOLUTION 1:

Check with DBA to ensure your user has permissions to execute SYS.DBMS_METADATA

RESOLUTION 2:

Ensure that the Oracle Client version you are using to connect to the database matches the database version as closely as possible

Running the following in the Editor will confirm which of the above solutions is required.

SELECT DBMS_METADATA.GET_DDL('TABLE', 'EMP', 'SCOTT') from dual (or a tablename and schema of your choice)

If you get error "ORA-24813: Cannot send or receive an unsupported LOB" then you have a client mismatch. Visit Oracle website to download the client version that nearest matches your database version.

Your user should have SELECT_CATALOG_ROLE to use the dictionaries called by SYS.DBMS_METADATA. Also you require execute permission for SYS.DBMS_METADATA itself.