Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

704 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