Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


text of a procedure


hey gurus  how can i find the text of a procedure.i mean the structure or defination of a perticuler procedure in the database   Thanks

select text from user_source where name='procedure_name'  if you are already logged in as that user, or if you have sys privs. then you can find the text from dba_source for that owner.

Try something like this:   select text from user_source where name = 'your procedure name here'   and type = 'PROCEDURE' order by line; 

or   SQL> set heading off; SQL> set echo off; SQL> Set pages 999; SQL> set long 90000; SQL> SET pagesize 0; SQL> SET linesize 100; SQL> COL ddl_txt for a96 word_wrapped; SQL> select dbms_metadata.get_ddl('PROCEDURE','ABC_1','SCOTT') from dual;

You can get it also from an export file.  Generate your dmp export file, then import it with the show=y option.  This will display the source code.  ~  Madrid.


Related Links

Is COST a funtion of time
opinions on backing up my environment
Export of table data
KUP-04036: second enclosing delimiter not found
Getting the sequence that is used in a trigger of a table for generic inser
Forgot password of user system
Error TNS:No Listener
Oracle JDBC driver - Unsupported parameter
How to copy schemas ?
adstats.sql
SQL LOADER ;;; PLEASE HELP ME
TNS-12502:
Forgot password of user system
Streams Capture status ABORT
Disable Job
What is PID and how to set it in ORADEBUG?