Re: sqlforms30 & oracle8

boggs wrote:
>
> Hi folks,
>
> Has anyone installed and executed successfully sqlforms30 on an oracle8
> database. If so, can someone please point me in the right direction? Thanks
> in advance.

I believe that it cannot be done.

Oracle 8 has a different format of the pseudo-cloumn ROWID. SQL*Forms version 3 cannot correctly handle these ROWIDs.

I have found that, running over SQL*Net with the runform30 client on a 7.1.4 system and the server running 8.0.5, I get errors with the messages:

 FRM-40501 ORACLE error -- unable to reserve record for update or delete.  ORA-01410: invalid ROWID

whenever I try to update a record which has a posted, but uncommitted, change.

I have concluded that Forms 3 has, at last, died.

-- 
Charles Jardine - Computing Service, University of Cambridge
cj10_at_cam.ac.uk    Tel: +44 1223 334506, Fax: +44 1223 334679