Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
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
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



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

Cant connect enterprise manager.
DB startup error
What should be wrong with documentation of ORA-00980 ?
SQL Plus question
how to create a procedure of Data pump
Oracle pipe timeout
logically grouping the procedures
oracle 8i installation ora-12560
Ora- 12535: operation timed out error.
Configuring ASM in Win2k3
Undo tablespace Issue
data guard, network disconnect error
Refresh a materialized view partition
export of a user from sys user
Rebuild or Re-Create Local Partitioned Bitmap Indexes?
Datapump dump file permissions on unix