OraFAQ Forum: SQL & PL/SQL » i want to find the string 'EMP1' which procedures have that string under the package

Home » SQL & PL/SQL » SQL & PL/SQL » i want to find the string 'EMP1' which procedures have that string under the package (oracle 11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

i want to find the string 'EMP1' which procedures have that string under the package [message #640573]

Thu, 30 July 2015 22:03

eswararaodba@gmail.com
Messages: 3
Registered: July 2015

Junior Member

Hi Team,

i have one package, under the package i have 70 procedures, i want to find the string 'EMP1' which procedures have that string under that package.
if i use dba_source its publishing package name only. not telling about procedures wise in that package.
can you please help here to find the procedure names under the package because i have to scan for entire schema.

Thanks in advance.

Thanks & Regards
Eswar

Report message to a moderator

Re: i want to find the string 'EMP1' which procedures have that string under the package [message #640574 is a reply to message #640573]

Thu, 30 July 2015 22:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: i want to find the string 'EMP1' which procedures have that string under the package [message #640575 is a reply to message #640573]

Fri, 31 July 2015 00:55

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have to scan the text in dba_source.

Report message to a moderator

Re: i want to find the string 'EMP1' which procedures have that string under the package [message #640581 is a reply to message #640575]

Fri, 31 July 2015 02:51

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

dba_source will give you the line numbers which will allow you to find the procedures manually. There's no easy way to get the procedure names in a query.

Report message to a moderator

Previous Topic:	Time period condition
Next Topic:	Union Join

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 00:13:48 CDT 2024