B.Vijay Karthik

• Jul 4th, 2005

 

Query user_source.text view for package,procedure,function source code

Rakesh Gautam

• Jul 5th, 2005

 

select text from dba_source where type='PACKAGE' and name=' '; 

Leon Parren

• Aug 29th, 2005

 

This only works if the package is not wrapped. The source code of

Sravan Anumala

• Sep 24th, 2005

 

source code of package resides in TEXT VARCHAR2(4000) column in the USER_SOURCE Data Dictionary Table

jagannimmagadda

 Profile Answers by jagannimmagadda 

• Jan 10th, 2006

 

for suppose package name is ABC select text from user_Source where type='PACKAGE' and name='ABC';

narasimha reddy

• May 20th, 2006

 

SELECT TEXT FROM USER_SOURCE/ALL_SOURCE/DBA_SOURCE

WHERE

NARASIMHA REDDY

• May 20th, 2006

 

SELECT TEXT FROM USER_SOURCE/ALL_SOURCE/DBA_SOURCE

WHERE NAME=<NAME OF THE PACKAGE> AND TYPE='PACKAGE';

HERE THE TYPE MAY BE PACKAGE,PROCEDURE,....