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
oracap
Messages: 1
Registered: March 2009
Location: UKJ
Junior Member
Hello,

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

SET_BLOCK_PROPERTY('B2',QUERY_DATA_SOURCE_NAME,'OEIC_RECALC.OEIPRICE');
SET_BLOCK_PROPERTY('B2',DML_DATA_TARGET_NAME,'OEIC_RECALC.OEIPRICE');

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.....

and

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

thanks
oracap
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
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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?

David
Previous Topic: How to assign a value to text item in particular format.
Next Topic: Ora-04062
Goto Forum:
  


Current Time: Wed Dec 07 20:10:39 CST 2016

Total time taken to generate the page: 0.17132 seconds