Home » Developer & Programmer » Forms » forms 6i will compatiable with Oracle 10g
forms 6i will compatiable with Oracle 10g [message #203259] Tue, 14 November 2006 09:01 Go to next message
Dobson1954
Messages: 18
Registered: October 2006
Location: US
Junior Member
We wanted to migrate our SQL forms 3.0 to oracle 6i. We wanted to know will oracle forms 6i will connect to 10g database?

If forms6i can connect to 10g we will go for conversion. Otherwise we wanted to develop from the scratch using forms 9i.

What do you recommend?

Thanks.
Re: forms 6i will compatiable with Oracle 10g [message #203295 is a reply to message #203259] Tue, 14 November 2006 12:07 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Direct conversion from Forms 3.0 to 6i is not possible - you'll first have to upgrade to 4.5, and then to 6i.

Forms 6i *should* work when connected to Oracle 10g. However, make sure you have the latest Patch (might be Patch #18, downloadable from Metalink). Also, database character set should be set to UTF8 (otherwise you might expect Forms to crash unexpectedly).
Re: forms 6i will compatiable with Oracle 10g [message #203352 is a reply to message #203259] Tue, 14 November 2006 19:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you even considering reqriting the application have you considered using Oracle's Application Express? It comes with 10g and uses PL/SQL for the low level stuff. Therefore, you will have a minimum of retraining. By the way Forms is up to 10g.

David
Re: forms 6i will compatiable with Oracle 10g [message #203358 is a reply to message #203259] Tue, 14 November 2006 20:57 Go to previous messageGo to next message
Dobson1954
Messages: 18
Registered: October 2006
Location: US
Junior Member
How easy it is, if i consider oracle express. We don't have idea on it. Can you give some idea on how to migrate SQL forms 3.0 to oracle express 10g

Thanks
Re: forms 6i will compatiable with Oracle 10g [message #203361 is a reply to message #203358] Tue, 14 November 2006 21:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You said
Otherwise we wanted to develop from the scratch using forms 9i.

'Scratch' to me means writing down the specification of the existing system and writing the application in a new language.

If I was doing it I would write down what we had and what we wanted.

I would look at the current data structure and see if it satisfied out new requirement. If it did - great, else rebuilt your data model and migrate the data. I would also look at all the (new) things that are available, for example, primary key, foreign keys, data types maybe, partitioning. (I would have to review what are the new features in the database and see which are or may be applicable to my new application.)

I would then look at each screen, see what is 'core' and get Application Express to build that bit for me. Then look at all the extras I want and work out whether I want to do them in the screen or in the database (its faster in the database). All this extra stuff is PL/SQL and again I would have to review the newer features available to me to see where I could improve the utility and speed of the application as I rewrote it. Remember that an easy way to handle the Forms code is to create a package per screen (Form) and move all the pure PL/SQL into that package. Just leave the screen manipulation stuff in the screen itself.

David

[Updated on: Tue, 14 November 2006 21:18]

Report message to a moderator

Re: forms 6i will compatiable with Oracle 10g [message #203609 is a reply to message #203259] Wed, 15 November 2006 15:48 Go to previous message
Dobson1954
Messages: 18
Registered: October 2006
Location: US
Junior Member
Thank you very much for information - littefoot and david.

our application is doing some ETL stuff. Most of our ETL interfaces are in PL/SQL. The user interface was written SQL * Forms.

We are updating reporitng tool and databases to latest versions (BOXIR2 and Oracle10g). So we are going to upgrate this ETL stuff as well.

Thank You.
Previous Topic: Standard Menu Button Problem
Next Topic: How to Save display forms column value when display item is more then one
Goto Forum:
  


Current Time: Sat Dec 10 14:45:01 CST 2016

Total time taken to generate the page: 0.35031 seconds