Home > IT Answers > Oracle > Converting and deploying 6i Forms to Forms 10g
Herbiebill
35 pts.
 Converting and deploying 6i Forms to Forms 10g
Converting 6i to 10g, Forms 10g, Forms 6i
I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that's true, then how do I run them? Is there a runtime with 10g? I feel like an idiot, but I don't know where to begin.

Software/Hardware used:
ASKED: April 22, 2009  8:17 PM
UPDATED: March 23, 2011  5:10 AM
RELATED QUESTIONS
Answer Wiki:
That is correct, you can't run applications in client-server mode in Forms 10g. Now, an <a href="http://download.oracle.com/docs/cd/B14101_10/docs.htm">Application Server</a> is needed. You can test/run your forms from Forms Builder without the app server, but to deploy them you will need it. There are some things that could need to be changed in your forms, for examlpe, AciveX, OCX, OLE or VBX controls are not supported and need to be replaced, mouse movement triggers are not supported either, and some built-ins or packages run in the server side only (TEXT_IO for example). Have a look at the following guide. It may help. <a href="http://download.oracle.com/docs/cd/B25521_01/doc/frs/forms/B15572_01/title.htm">Oracle® Forms Migrating Forms Applications From Forms 6i to 10g (10.1.2.0.2) for Windows and UNIX </a>
Last Wiki Answer Submitted:  April 22, 2009  9:53 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for info and the documentation reference! When I try to compile the 6i applications in 10g, I get an error message for each table saying that they must be declared. Any ideas why?

The tables are in a 9i database and reside in the same schema name that I’m using to connect Developer 10g to the database. Since the tables are owned by the user ID I’m logging in with, they shouldn’t require synonyms or owner/instance references. When I log into SQLPlus using the same credentials, I have no problem seeing the tables.

I’m beginning to wonder if I can use Developer 10g in a 9i database. Any advice would be appreciated.

-Bill Pearson

Herbiebill
 35 pts.
 

I think it should work. I have succesfully compiled a 10g form against an 8i database, so I guess it should also work with 9i.

Also, if the user is the owner of the tables, no synonyms are needed, you are right.

When you connect from SQL*Plus, are you sure you are using the executable from the Developer 10g installation ? If you have the database client software installed, you could be using that version.

Are you completely sure that forms builder is connected to the database ? (sorry, I had to ask)

carlosdl
 63,535 pts.
 

Thank you Carlos! I don’t know why it made a difference, but my versions were off. I must have installed Developer 10g version 1. When I uninstalled version 1 and installed version 2 I was able to compile the form.

I don’t know if I was really connecting to the DB or not, but if you hadn’t challenged me to look harder, I would never have noticed the dichotomy between the two SQLPlus versions I was using.

Thanks again,
-Bill Pearson

Herbiebill
 35 pts.
 

Oracle-10g Database is not connected by Oracle developer 6i

Oracledevloper
 10 pts.