Re: Problems with Forms30 in Oracle 8.0.5.1

Hello.
We have an application (about 1000 forms) developed in forms30 and Oracle 6 (later 7.2) and now we need to migrate to Oracle 8. We have found the same problems you describe, but we believe we have found a solution (at that moment, we did not know that there was a path). It is based in the manage of the format of pseudo column ROWID. There is a database function, called "rowid_to_extend" (see package dbms_rowid) that convert old rowid format to new Oracle 8 rowid extended format. Using this function in apropiate form triggers we have solved the problem. On the other hand, we have implement a program (a filter) to add or modify these triggers automatically.
At the moment we are probing the filter on complex forms and it seems that it works!

Comment: We know that explicit use of rowid is not recomended, but the problem is due to the internal use of rowid by forms30 to synchornize the records of basetable blocks with database records and the diferent format of these rowids. So the only way to solve this is using rowids (we believe).

Miguel Angel Olmedo (MAngel.Olmedo_at_carm.es) D.G. Informática
Comunidad Autónoma de Murcia.
Spain.

---

>Piotr Kolodziej escribió en mensaje <7ilhnv$aiq$1_at_korweta.task.gda.pl>...
>Julio Negueruela wrote in message <374E4330.79556DF9_at_si.unirioja.es>...
>>I think they length is the same, what has changed is both the format and
>>the base, in 7 it's base 16 and in Oracle 8 it's base 64.
>
>
>Julio, there was a patch to libora.a library which enabled clients linked
>with 7.x (7.3.2 and below I believe) libraries to handle properly Oracle8
>ROWID. It was included to some Oracle 8.0.3 distributions.
>Unfortunetally, Oracle 8.0.4 and above releases have some other serious
>issues which cause quite frequent core dumps of Oracle shadow processes
>with clients linked with pre-7.3 libraries.
>That's why pre-7.3 clients and RDBMS 8.0.4+ configurations are not
>certified by Oracle, I suppose.
>
>--
>Piotr Kolodziej
>pkol_at_otago.gda.pl
>
Received on Fri May 28 1999 - 03:34:47 CDT