View Compiled Package (store procedure)

Posted on 1999-07-06
Medium Priority
Last Modified: 2009-12-16
I have a program calling the store procedure "myVesselPkg.sql".  This package have been compiled in SQLplus.  

I do not have the scripts and I would like to view the content of the said store procedure in sql mode.

Can I do that ?  What is the sql statement to use...

Thank you.
Question by:ycgoh

Accepted Solution

bkesarla earned 40 total points
ID: 1087268

 From the data dictionary table user_source/all_source/dba_source, it is possible to get the text of the stored procedure.

 The Sql command for the same is :

  Select text from user_source where name='<name of the stored procedure>';


Author Comment

ID: 1087269
cool... 8))


Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question