PL/SQL (MOSC)

MOSC Banner

object dependency is empty

edited Feb 8, 2017 1:25PM in PL/SQL (MOSC) 12 commentsAnswered

Hi

Can anybody clear my doubt/problem issue.

During parsing of a pl/sql block, Object dependencies are not listed in v$object_dependency view when bind variables are used .But object dependencies are displayed when values/literals are passed on to it.

Version :12.1.0.2

Dependencies are not displayed :

DECLARE P NUMBER; BEGIN A:=TEST(:VAR);END;;

Dependencies are displayed :

DECLARE P NUMBER ; BEGIN A:=TEST(:10);END;;

Thanks

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