Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

is forms 6i on Oracle Database 12.2 compatible?

user8612887Apr 5 2017 — edited Apr 13 2017

Hi,

I want to run a forms 6i application against database 12R2 and I want to know if they are compatible (I'm asking not for certification).

The same applicatin will run against Database 12R1 without any problems.

Thank,.

Detlef

Comments

Kalpataru

The simple answer is no.

Why because it is the Oracle Database 12.2 is unsupported for Oracle Forms 6i.

Check this thread for more information. how connect forms 6i with oracle 12c .

Hope it helps you.

user8612887

The thread you refer to is still open and not answered.

I know that the combination of forms 6i and 12 (alo 11 and 10) is not supported and forms 6i runs well against 12R1 and any version of 11 and 10.

I can connect to database 12R2 but calling exit_form or call_form build-ins I got erros (frm40655 or ora03114).

thanks for more help.

There are two issues here.

1.  Forms 6.0.8.10+, which is based on oracle 8.0.6, has been desupported for over 10 years.  This is long before v12 of the db was even a dream.  Beginning in db 8.1.7, some significant changes were introduced into the db.  The most significant being the change to ROWID.  Of course there were many others.  Some of these changes are not directly compatible with 8.0 clients (like Forms 6) and older.  Further, if it matters, Oracle never certified nor supported the use of db versions newer than 8.1.7 with Forms 6.  There is the exception of using EBS, but special patches must be installed into EBS in order for things to be expected to work correctly.

2.  The fact that you can connect is trivial.  The issues is whether or not data base be safely managed (inserted, updated, deleted).

My personal opinion is that I would not put a production environment at risk of data corruption by using an un-certified and unsupported configuration.  Why are you still using Forms 6i??  The latest is 12.2.1.2 and new versions is planned for release soon.  It's probably time to consider modernizing the application layer along with your db.

user8612887

I know that forms 6i is desupported.

what do you with "The issues is whether or not data base be safely managed (inserted, updated, deleted)." could you give more detailed information ?

Thanks,

Detlef

Johnson F

Recommended option and the only option you have is to upgrade your forms/reports to 12c version.

Gary_A

user8612887, I want to ask, how were you able to connect 6i to 12.2?

I have 6i running against 12.1 with no problem, but forms 6i crashes when connecting to a 12.2 database.

What do your sqlnet.ora and tnsnames.ora files look like for Forms 6i?

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2017
Added on Apr 5 2017
6 comments
1,670 views