| forms 6i will compatiable with Oracle 10g [message #203259] |
Tue, 14 November 2006 09:01  |
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 #203361 is a reply to message #203358] |
Tue, 14 November 2006 21:18  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
