Solved

display a stored procedure

Posted on 2004-10-20
3
2,220 Views
Last Modified: 2007-11-27
running oracle 8.1.7.2.  how can i display a stored procedure from the sqlplus command line?  i'm getting a bunch of junk on google and this is driving me nuts! thanks.

0
Comment
Question by:benpung
[X]
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
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
paquicuba earned 50 total points
ID: 12363710
To find the procedures:
SELECT OBJECT_NAME, OBJECT_TYPE FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE';
or
SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE';

to see the text:
SELECT TEXT FROM ALL_SOURCE WHERE NAME = < procedure name>;
or
SELECT TEXT FROM USER_SOURCE WHERE NAME = < procedure name>;


Hope this helps!
0
 
LVL 1

Author Comment

by:benpung
ID: 12363732
Thanks!
0
 
LVL 23

Expert Comment

by:paquicuba
ID: 12364320
You're Welcome!
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

728 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