Home » Developer & Programmer » Forms » Forms 6i and Oracle 10g R2
Forms 6i and Oracle 10g R2 [message #253615] Tue, 24 July 2007 07:19 Go to next message
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.
Re: Forms 6i and Oracle 10g R2 [message #255158 is a reply to message #253615] Mon, 30 July 2007 20:20 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Forms 6i and Oracle 10g R2 [message #255258 is a reply to message #255158] Tue, 31 July 2007 04:00 Go to previous messageGo to next message
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.

Re: Forms 6i and Oracle 10g R2 [message #256049 is a reply to message #255258] Thu, 02 August 2007 20:25 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Create text file
Next Topic: Function that can tell is the given STRING is a set of CHARACTER or NUMBER?
Goto Forum:
  


Current Time: Mon Dec 05 08:38:49 CST 2016

Total time taken to generate the page: 0.05115 seconds