FULL OUTER JOIN Fails when used on views that access PL/SQL objects that are not in the current user
- We have two views.
- One of these contain reference to a PL/SQL procedure in the same schema as the views
- Another user (not the schema owner) accessing these views
- The SQL fails when the FULL OUTER JOIN is used saying that the PL/SQL object is not there (ORA-00904: "GET_DESCRIPTION": invalid identifier).
- The same query works perfect if the FULL OUTER JOIN is replaced with LEFT OUTER JOIN or RIGHT OUTER JOIN.
Please try the SQL in the attachment.