Home » Developer & Programmer » Forms » Your help required....schema issue in forms (Forms 6i and Oracle 9i database)
Your help required....schema issue in forms [message #390431] Fri, 06 March 2009 05:35 Go to next message
Messages: 1
Registered: March 2009
Location: UKJ
Junior Member

I connect to my forms 6i application through normal user login and user's schema. However on accessing a particular screen in a specific way i have to change the schema for any dml's.

I have been able to do this successfully by using the following forms property


and opening cursors differently (as per the required schema : FCS or oeic_recalc) internally within the form

i also checked the inserts and updates happen correctly when i enter the screen and process a single record

However if i process a second record simultaneously without exiting and re-entering the screen i am getting FRM-40654:Record has been updated by another user.....


ORA-01410 subsequently

I a having a feeling this is happening b'cos my changes for some reason are not getting committed on the oeic_recalc schema as shown above and the table is getting locked or something

i am not sure of this

i did see your solutions for FRM-40654 but they have not been helpful. I am unable to pinpoint the error and seek your urgent help

i would be greatful if anyone can give me some pointers and/or solutions

please let me know if i eed to give more information

Re: Your help required....schema issue in forms [message #394180 is a reply to message #390431] Thu, 26 March 2009 00:05 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

Do you have a tool like 'toad' so that you can see the locks and blocking locks?

Previous Topic: Browser working only in LocalAdmin Mode
Next Topic: Master Detail Blocks Multiple Master Rows and Multiple Detail Rows
Goto Forum:

Current Time: Wed Aug 23 01:10:49 CDT 2017

Total time taken to generate the page: 0.13811 seconds