We are having several applications developed on Oracle 7.3 Forms 4.5 Reports 2.5 platform. The applications consist of forms, reports, stored procedures, functions. Few months back, we migrated the database to Oracle 9i but the front-end was retained as it is. Now we intend to migrate the application to 6i. We have not chosen 9i as we understand that we would have to be complusorily on 3 tier architecture for that and we do not want to go in for the application server licencing and the associated costs. We understand that with 6i, we can continue with the client server mode.
What I would like to know is : 1) Is it just as simple as opening each form and compiling the same in 6i ? 2) Any reference material available on this ? 3) Any books we can refer ?
As users are happy with the application, we would not like to keep changes, if needed, to the minimum.