Home » Developer & Programmer » Forms » How to find out the name of the Stored Procedures that are used in a form? (forms 10G)
How to find out the name of the Stored Procedures that are used in a form? [message #381875] Tue, 20 January 2009 03:19 Go to next message
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.
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 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
Go to form builders menu "Program">find replace pl/sql.
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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
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 Go to previous messageGo to next message
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?
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 Go to previous messageGo to next message
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


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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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).
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 Go to previous messageGo to next message
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.
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum and the web site for 'Forms*Tool'. It may be able to help you.

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


Current Time: Sat Dec 10 06:52:40 CST 2016

Total time taken to generate the page: 0.17484 seconds