list of all functions/procedures called by each function/procedure in an oracle package
up vote
0
down vote
favorite
is there a table in oracle that lists all functions/procedures called by each function/procedure in an Oracle package? I wanted to know how each function/procedure is related to other functions/procedures within the package, and the connection between each of them.
oracle plsql
edited Nov 9 at 11:07
APC
116k15114227
asked Nov 9 at 10:52
Visioneer Paperport
63
add a comment |
up vote
0
down vote
favorite
is there a table in oracle that lists all functions/procedures called by each function/procedure in an Oracle package? I wanted to know how each function/procedure is related to other functions/procedures within the package, and the connection between each of them.
oracle plsql
edited Nov 9 at 11:07
APC
116k15114227
asked Nov 9 at 10:52
Visioneer Paperport
63
1
You can generate this information using the PLSCOPE compiler flag. Find out more
– APC
Nov 9 at 11:07
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
is there a table in oracle that lists all functions/procedures called by each function/procedure in an Oracle package? I wanted to know how each function/procedure is related to other functions/procedures within the package, and the connection between each of them.
oracle plsql
edited Nov 9 at 11:07
APC
116k15114227
asked Nov 9 at 10:52
Visioneer Paperport
63
is there a table in oracle that lists all functions/procedures called by each function/procedure in an Oracle package? I wanted to know how each function/procedure is related to other functions/procedures within the package, and the connection between each of them.
oracle plsql
oracle plsql
edited Nov 9 at 11:07
APC
116k15114227
asked Nov 9 at 10:52
Visioneer Paperport
63
edited Nov 9 at 11:07
APC
116k15114227
asked Nov 9 at 10:52
Visioneer Paperport
63
edited Nov 9 at 11:07
APC
116k15114227
edited Nov 9 at 11:07
APC
116k15114227
edited Nov 9 at 11:07
APC
116k15114227
116k15114227
asked Nov 9 at 10:52
Visioneer Paperport
63
asked Nov 9 at 10:52
Visioneer Paperport
63
asked Nov 9 at 10:52
Visioneer Paperport
63
63
1
You can generate this information using the PLSCOPE compiler flag. Find out more
– APC
Nov 9 at 11:07
add a comment |
1
You can generate this information using the PLSCOPE compiler flag. Find out more
– APC
Nov 9 at 11:07
1
1
You can generate this information using the PLSCOPE compiler flag. Find out more
– APC
Nov 9 at 11:07
You can generate this information using the PLSCOPE compiler flag. Find out more
– APC
Nov 9 at 11:07
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
you can have a look at all_dependencies/user_Dependencies/dba_dependencies and filter out by the object_type
answered Nov 9 at 11:23
George Joseph
62226
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
you can have a look at all_dependencies/user_Dependencies/dba_dependencies and filter out by the object_type
answered Nov 9 at 11:23
George Joseph
62226
add a comment |
up vote
0
down vote
you can have a look at all_dependencies/user_Dependencies/dba_dependencies and filter out by the object_type
answered Nov 9 at 11:23
George Joseph
62226
add a comment |
up vote
0
down vote
up vote
0
down vote
you can have a look at all_dependencies/user_Dependencies/dba_dependencies and filter out by the object_type
answered Nov 9 at 11:23
George Joseph
62226
you can have a look at all_dependencies/user_Dependencies/dba_dependencies and filter out by the object_type
answered Nov 9 at 11:23
George Joseph
62226
answered Nov 9 at 11:23
George Joseph
62226
answered Nov 9 at 11:23
George Joseph
62226
answered Nov 9 at 11:23
George Joseph
62226
62226
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53224304%2flist-of-all-functions-procedures-called-by-each-function-procedure-in-an-oracle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
You can generate this information using the PLSCOPE compiler flag. Find out more
– APC
Nov 9 at 11:07