Re: forms 4.5 error against oracle 8i db...

Yes, this is exactly the error that occurs when you run a version of 4.5 that has not been patched to work with 8i. This is because of the rowid format change in 8i -- the rowid is used for locking in forms.

You need to upgrade your version of 4.5 or convert to 6i. I believe there is also a way to run an 8i database in Oracle 7 compatibility mode where the rowids are formatted the old way, but I'm not familiar with that. Patching 4.5 or upgrading to 6i is the better approach.

Marc Perkowitz
Senior Consultant
TWJ Consulting, LLP

847-256-8866 x15
www.twjconsulting.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, May 24, 2001 6:50 AM

> Hi,
> has anyone encounted errors for the post built-in when the form is run
> against 8i db?
> I have a situation here, wherein, if I run forms 4.5 generated .fmx
against
> oracle 7.3 db, it works fine. But when I run the same form against 8i db,
> the post built-in is generating the error "frm 40501: oracle error: unable
> to reserve record for update or delete".
>
> Note, the first time the post is executed in the session, no error is
> generated, but from the second time onwards, the above error is
encountered.
>
> Thanks
> Amar Kumar Padhi.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Amar Kumar Padhi
> INET: TS2017_at_emirates.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marc Perkowitz
  INET: mperkowitz_at_twjconsulting.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).