OraFAQ Forum: Forms » Forms 6i and Oracle 10g R2

Home » Developer & Programmer » Forms » Forms 6i and Oracle 10g R2

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

Forms 6i and Oracle 10g R2 [message #253615]

Tue, 24 July 2007 07:19

lijojoseph
Messages: 9
Registered: July 2007
Location: Mumbai

Junior Member

Hello,

I have an application which is in ORACLE FORMS6i (Patch 2).The database which forms access is oracle 10gR2. When ever we issues a FORMS_DDL and if somebody opened a record for update in any table then application gets hanged.If we release the tuple (which is locked for update with nowait) then it works fine

Can you please suggest solutions to avoid this locking.

Report message to a moderator

Re: Forms 6i and Oracle 10g R2 [message #255158 is a reply to message #253615]

Mon, 30 July 2007 20:20

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please post the code associated with your FORMS_DDL statements.

FORMS_DDL performs a commit whether you want it or not.

Why are you using manual update statements?

David

Report message to a moderator

Re: Forms 6i and Oracle 10g R2 [message #255258 is a reply to message #255158]

Tue, 31 July 2007 04:00

lijojoseph
Messages: 9
Registered: July 2007
Location: Mumbai

Junior Member

David... thanks for the reply.
We use FORMS_DDL to change the passwords of a user. so the code associated with FORMS_DDL is alter user <username> identified by <new password>.

The updatio nof records is done from the application only, nowait is used so that no 2 users cannot update at the same time.

Report message to a moderator

Re: Forms 6i and Oracle 10g R2 [message #256049 is a reply to message #255258]

Thu, 02 August 2007 20:25

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry, but your reply does not tell me whether you have solved your problem or not solved your problem. You also have not said why you are using a manual 'update' nor have you posted the code that is causing the problem as I requested.

David

Report message to a moderator

Previous Topic:	Create text file
Next Topic:	Function that can tell is the given STRING is a set of CHARACTER or NUMBER?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 18:54:59 CST 2025