OraFAQ Forum: Forms » Text Search on Oracle Forms

Home » Developer & Programmer » Forms » Text Search on Oracle Forms

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

Text Search on Oracle Forms [message #397004]

Wed, 08 April 2009 10:37

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

Report message to a moderator

Re: Text Search on Oracle Forms [message #397065 is a reply to message #397004]

Wed, 08 April 2009 14:34

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: Text Search on Oracle Forms [message #397093 is a reply to message #397004]

Wed, 08 April 2009 21:34

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Thanks Nice one.

kanish

Report message to a moderator

Re: Text Search on Oracle Forms [message #397274 is a reply to message #397004]

Thu, 09 April 2009 14:09

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.

Report message to a moderator

Re: Text Search on Oracle Forms [message #397315 is a reply to message #397274]

Fri, 10 April 2009 01:00

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: Text Search on Oracle Forms [message #398030 is a reply to message #397315]

Tue, 14 April 2009 23:40

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

Senior Member
Account Moderator

Look at 'FormsTool' at http://www.orcl-toolbox.com/

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 09:05:42 CST 2025