OraFAQ Forum: Forms » automate forms conversion.

Home » Developer & Programmer » Forms » automate forms conversion. (6i,10gas ,xp ,RHEL 4)

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

automate forms conversion. [message #296755]

Mon, 28 January 2008 23:46

varu123
Messages: 754
Registered: October 2007

Senior Member

I am in a process to migrate the forms and reports 6i to 10G AS.
The first thing to do is to make the forms and reports compile in 10G AS.
The first thing to do is to replace CALL built in with CALL_FORM.

Since there are hundreds of forms,Is there any automated way to replace the above built in or do i have to do it manually one by one tediously?

Report message to a moderator

Re: automate forms conversion. [message #296797 is a reply to message #296755]

Tue, 29 January 2008 01:43

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

Senior Member
Account Moderator

I used Search and Replace; it is a program ...

Quote:

... for finding text in files and performing advanced search / replace operations on text or binary files using grep style regular expressions. The many features include searching files in ZIPs, HTML mode, clipboard search/replace, & more

Perhaps you'll find it useful.

Report message to a moderator

Re: automate forms conversion. [message #296805 is a reply to message #296755]

Tue, 29 January 2008 02:07

varu123
Messages: 754
Registered: October 2007

Senior Member

Would it work on linux?

Report message to a moderator

Re: automate forms conversion. [message #296808 is a reply to message #296755]

Tue, 29 January 2008 02:17

varu123
Messages: 754
Registered: October 2007

Senior Member

It does not recognize fmb files in windows

Report message to a moderator

Re: automate forms conversion. [message #296809 is a reply to message #296808]

Tue, 29 January 2008 02:29

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

Senior Member
Account Moderator

It does on my Windows XP SP2 (using Search and Replace 5.1)

/forum/fa/3826/0/

Attachment: search_replace.PNG
(Size: 17.34KB, Downloaded 908 times)

Report message to a moderator

Re: automate forms conversion. [message #296820 is a reply to message #296755]

Tue, 29 January 2008 03:10

varu123
Messages: 754
Registered: October 2007

Senior Member

I need to change CALL with CALL_FORM in the code in the various triggers in fmb files.
I don't see it doing this.

Report message to a moderator

Re: automate forms conversion. [message #296855 is a reply to message #296755]

Tue, 29 January 2008 06:10

varu123
Messages: 754
Registered: October 2007

Senior Member

I wrote a shell script to automate the process.

#!bin/bash
mkdir temp
for file in $@
do
sed 's/call/call_form/g' $file > temp/$file
mv temp/$file $file
done

but i forgot that plsql is written behind the file.
And fmb files are binary files.
So this won't work for fmb files.
Does any one know how to modify it to solve the purpose?

Report message to a moderator

Re: automate forms conversion. [message #296863 is a reply to message #296820]

Tue, 29 January 2008 06:23

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

Senior Member
Account Moderator

varu123 wrote on Tue, 29 January 2008 10:10

I need to change CALL with CALL_FORM in the code in the various triggers in fmb files.
I don't see it doing this.

I don't have any 'CALL' in my forms to change it to 'CALL_FORM'. So, I changed 'ocit' to 'al_me_gnjavis'. Do I need to create a form which will show you an exact example of what you'd like to see?

/forum/fa/3830/0/

Attachment: search_replace_2.PNG
(Size: 17.56KB, Downloaded 889 times)

Report message to a moderator

Re: automate forms conversion. [message #296873 is a reply to message #296755]

Tue, 29 January 2008 06:47

varu123
Messages: 754
Registered: October 2007

Senior Member

But in the form,i do not see the changes.

Report message to a moderator

Re: automate forms conversion. [message #297034 is a reply to message #296873]

Tue, 29 January 2008 23:36

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

Senior Member
Account Moderator

Have you considered using Oracle's Migration Assistant? For more information search for 'Migration Assistant' on either this site, Oracle's main site, or google.

David

Report message to a moderator

Previous Topic:	FRM-40102 while calling new form in between a multi record block
Next Topic:	Menu attached to a form appears on MDI Window in 10g !!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 19:03:01 CDT 2025