OraFAQ Forum: Forms » How to find out the name of the Stored Procedures that are used in a form?

Home » Developer & Programmer » Forms » How to find out the name of the Stored Procedures that are used in a form? (forms 10G)

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

How to find out the name of the Stored Procedures that are used in a form? [message #381875]

Tue, 20 January 2009 03:19

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

How to find out the name of the Stored Procedures/Functions/Package that are used in a form?

Thanks in advance,
Guru.

Report message to a moderator

Re: How to find out the name of the Stored Procedures that are used in a form? [message #382317 is a reply to message #381875]

Wed, 21 January 2009 23:01

parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune

Senior Member

Go to form builders menu "Program">find replace pl/sql.

Report message to a moderator

Re: How to find out the name of the Stored Procedures that are used in a form? [message #382386 is a reply to message #382317]

Thu, 22 January 2009 01:57

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Right; unfortunately, this helps when you know procedure's name. Guru would like to find ALL stored procedures that are used in a form (and he doesn't know their names). You know, something like

C:\> search_form form=emp.fmb find=stored_procedures

pkg_some_package
fun_return_salary
prc_insert_employee

Report message to a moderator

Re: How to find out the name of the Stored Procedures that are used in a form? [message #382649 is a reply to message #382386]

Fri, 23 January 2009 07:38

gurupatham
Messages: 66
Registered: March 2008
Location: Chennai

Member

Yes Exactly i want like this. Is there any script like what you have stated? OR Any others way to find out the stored procedure that are used in a form?

Report message to a moderator

Re: How to find out the name of the Stored Procedures that are used in a form? [message #382652 is a reply to message #381875]

Fri, 23 January 2009 07:58

parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune

Senior Member

Hi Littlefoot,
which command is this. where shall i put this command. How windows will recognize "search_form".

C:\> search_form form=emp.fmb find=stored_procedures

Report message to a moderator

Re: How to find out the name of the Stored Procedures that are used in a form? [message #382708 is a reply to message #382652]

Fri, 23 January 2009 12:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It was just an example; as far as I know, "search_form" executable does not exist - I have just made it up in order to illustrate what Guru wants (as you didn't understand the question).

Report message to a moderator

Re: How to find out the name of the Stored Procedures that are used in a form? [message #382985 is a reply to message #381875]

Mon, 26 January 2009 22:49

parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune

Senior Member

OK. I think on this issue a lot and finally come to conclusion that "finding names of stored procedures when you don't know names, is not possible". If anybody knows how to do then please share with us.

Report message to a moderator

Re: How to find out the name of the Stored Procedures that are used in a form? [message #383019 is a reply to message #382985]

Tue, 27 January 2009 00:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search this forum and the web site for 'Forms*Tool'. It may be able to help you.

David

Report message to a moderator

Previous Topic:	showing LOV
Next Topic:	Regarding 6i to 10g Conversion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 18:08:30 CST 2025