SQL Language (MOSC)

MOSC Banner

FULL OUTER JOIN Fails when used on views that access PL/SQL objects that are not in the current user

edited Apr 21, 2011 9:26PM in SQL Language (MOSC) 3 commentsAnswered ✓
FULL OUTER JOIN Fails when used on views that access PL/SQL objects that are not in the current users schema

- 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center