Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 442 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Tables used by a procedure in a package
513463
Member Posts: 32
Hi Gurus,
I have a package, and a procedure inside that package is accessing some tables and interacting with some other functions lets say...
In general dependencies of tables can be found using user_dependencies view, and I tried the same even for my scenario, but failed.
But if I try to find dependencies for standalone procedure (not embedded into a package), I can find the details.
This is not working for the procedures embedded inside a package.
Please help me if there is any way of knowing those dependencies for my scenario.
Thanks & Regards
RK Veluvali
Edited by: RK Veluvali on Feb 15, 2010 8:34 PM
I have a package, and a procedure inside that package is accessing some tables and interacting with some other functions lets say...
In general dependencies of tables can be found using user_dependencies view, and I tried the same even for my scenario, but failed.
But if I try to find dependencies for standalone procedure (not embedded into a package), I can find the details.
This is not working for the procedures embedded inside a package.
Please help me if there is any way of knowing those dependencies for my scenario.
Thanks & Regards
RK Veluvali
Edited by: RK Veluvali on Feb 15, 2010 8:34 PM
Tagged:
Answers
-
In general dependencies of tables can be found using user_dependencies view, and I tried the same even for my scenario, but failed.What do you mean by "Failed"? What query did you try? Did you specify the package name or the procedure name?
You must specify the package name. You cant be using the procedure name. Its a local procedure and oracle does not log it into the data dictionary. -
Hi Karthick,
I tried using the following query.
select * from dba_objects
where object_name like <>;
As you specified, if Oracle does not take the local procedures inside a package into its data dictionary, my query could not get any results for the procedure I specified above.
We are about to kickoff for a code optimization and DB normalization, for this we want to know if a procedure has to be changed, what all tables are being used by it, using which we can lay our plan of action.
So please suggest me a way to get dependancies of the procedure, written inside a package, or if it is not possible please give me your suggestions and let me know how we can proceed further.
Thank you so much in advance.
Regards
RK Veluvali -
Hi Gurus,
Can any one help me...
This discussion has been closed.