OraFAQ Forum: Forms » Your help required....schema issue in forms

Home » Developer & Programmer » Forms » Your help required....schema issue in forms (Forms 6i and Oracle 9i database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Your help required....schema issue in forms [message #390431]

Fri, 06 March 2009 05:35

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

Report message to a moderator