Home » Developer & Programmer » Forms » Text Search on Oracle Forms
Text Search on Oracle Forms [message #397004] Wed, 08 April 2009 10:37 Go to next message
yog_23
Messages: 79
Registered: March 2007
Member
I have a situation where I have tons of oracle forms.

I need to perform a text search on oracle forms to find if any forms reference any oracle package / function / procedure / table.

E.g. LOG_NOTIFY is a package, need to find how many forms use this package.

Whats the best way to do this. Are there any tools / program available ?

Thank you
Yog
Re: Text Search on Oracle Forms [message #397065 is a reply to message #397004] Wed, 08 April 2009 14:34 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Is your server on Windows/Unix?
You can change the fmb to text file using Administration -> convert -> Binary - Text

If it is Unix server you can use grep on the fmb itself. You can also do the grep to see the line where the package occurrence is there using the text file.

By
Vamsi
Re: Text Search on Oracle Forms [message #397093 is a reply to message #397004] Wed, 08 April 2009 21:34 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Thanks Nice one.

kanish
Re: Text Search on Oracle Forms [message #397274 is a reply to message #397004] Thu, 09 April 2009 14:09 Go to previous messageGo to next message
yog_23
Messages: 79
Registered: March 2007
Member
Thank you..

Can we do this programatically instead opening the forms and saving to a file ?

Thanks again.
Re: Text Search on Oracle Forms [message #397315 is a reply to message #397274] Fri, 10 April 2009 01:00 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Still you didn't answer my question..
Is your server on Windows/Unix?
Also you haven't mentioned the forms release.. 6i / 9i or 10g.

If it is 6i on Unix, you can use f60genm with Forms_Doc=Yes
For 10g I think it is frmcmp.
For others I don't know.

anyway you can list the forms and add this command to that programatically or using any editor then you can run it to get the txt files accordingly.

By
Vamsi
Re: Text Search on Oracle Forms [message #398030 is a reply to message #397315] Tue, 14 April 2009 23:40 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at 'FormsTool' at http://www.orcl-toolbox.com/

David
Previous Topic: Use the Selected items in Another Blocks
Next Topic: content canvas
Goto Forum:
  


Current Time: Thu Dec 08 10:09:08 CST 2016

Total time taken to generate the page: 0.12301 seconds