Hi,

I have one Oracle standalone procedure.In this am doing truncating the data and loading the new data into the target table.
The issue is , I want to know whether the table is callable from other procedure,if it it callable I want to know the Procedure or Packages list.

and want to know the related child tables from the system table?

Is it possible to write any program for this? Please share your ideas...

I really do not understand what is the table is callable from other procedure.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.