Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Finding out all procedures , functions in a tree like structure in sequence

ora_1978Sep 6 2012 — edited Sep 6 2012
Example:

Say i have packages

pack1 - Master package
pack1proc1 - calls pack2proc1
pack1proc2 - calls pack3proc1

pack2
pack2proc1 - calls pack4proc1
pack2proc2 - calls pack4proc2
pack2proc3


pack3
pack3proc1

packn
.
.
.
.
-----

The above is just an example. My requirement when i pass master package (pack1) as input , i should get all chain of procedures in the dictionary upto any level. I know we have database dictionary user_dependencies, deptree, ideptree. But not sure of how to use that. Please give a query to get the chain of procedures.

Table is not needed. Only procedures and functions.

thanks,
Vinodh

Comments

Maahjoor
Answer

The solution is you have to provide the proper home

https://community.oracle.com/thread/3817750

so once you get the error, set the BI_PRODUCT_HOME : C:\Middleware\Oracle_Home\bi in environmental variable,

run the rcu.bat to remove the users, delete the directory of C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi and rerun the rcu.bat and rerun the config.exe

REgards.

Marked as Answer by Maahjoor · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 4 2012
Added on Sep 6 2012
11 comments
4,541 views