Form Displaying Old version of data [message #669255] |
Tue, 10 April 2018 08:32  |
manyal
Messages: 84 Registered: March 2005
|
Member |
|
|
Dear Friends,
I am facing one problem, while displaying data through the form, sometimes when I execute the data in the form, I see the old version of data and newly inserted data is also not visible, as soon as I exit the form and reopen the form and executes, I am able to view the latest version of data.
please guide me in this regard.
Manyal
|
|
|
|
|
|
|
Re: Form Displaying Old version of data [message #669283 is a reply to message #669282] |
Thu, 12 April 2018 04:00   |
cookiemonster
Messages: 13966 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
They should be yes.
Try running the query the problem form would run in a seperate sqlplus (other DB tools are available) session at the same time and see what you get.
You can also try tracing the form session and see if it's actually re-querying the data when you think it is and if it's issuing the query you think it is.
|
|
|
Re: Form Displaying Old version of data [message #669393 is a reply to message #669283] |
Fri, 20 April 2018 01:06   |
manyal
Messages: 84 Registered: March 2005
|
Member |
|
|
Actually some of the forms in my application were opening with isolation mode "serializable" and if we open anyone of these forms this property remains persists even if we open the another new form with property set as isolation mode "read committed", so I had to set isolation mode explicitly "read committed" at when new_form_instance trigger of all the forms in my application, in this way my problem was resolved
|
|
|
|
|
|
|
|
Re: Form Displaying Old version of data [message #669461 is a reply to message #669442] |
Tue, 24 April 2018 00:48  |
manyal
Messages: 84 Registered: March 2005
|
Member |
|
|
instead of trigger is working fine when i update the view through sql developer, but when it was updated through form using commit form it was raising some locking issues, that's why i had to make the form with isolation mode as 'serializable'
|
|
|