Home » Developer & Programmer » Forms » Form Displaying Old version of data (forms 11g )
Form Displaying Old version of data [message #669255] Tue, 10 April 2018 08:32 Go to next message
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 #669256 is a reply to message #669255] Tue, 10 April 2018 08:36 Go to previous messageGo to next message
cookiemonster
Messages: 13120
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you inserting the new data in the same session from which you are trying to view it or a different one?
Re: Form Displaying Old version of data [message #669265 is a reply to message #669256] Tue, 10 April 2018 22:52 Go to previous messageGo to next message
manyal
Messages: 84
Registered: March 2005
Member
Data are being inserted and modified in other sessions
Re: Form Displaying Old version of data [message #669269 is a reply to message #669265] Wed, 11 April 2018 08:10 Go to previous messageGo to next message
BlackSwan
Messages: 26004
Registered: January 2009
Location: SoCal
Senior Member
Other session can NOT see uncomitted rows or changed rows after this session starts
Re: Form Displaying Old version of data [message #669282 is a reply to message #669269] Thu, 12 April 2018 03:08 Go to previous messageGo to next message
manyal
Messages: 84
Registered: March 2005
Member
but I think if we re-execute the data on oracle forms, committed transactions on others sessions must also be visible on same session
Re: Form Displaying Old version of data [message #669283 is a reply to message #669282] Thu, 12 April 2018 04:00 Go to previous messageGo to next message
cookiemonster
Messages: 13120
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 Go to previous messageGo to next message
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 #669394 is a reply to message #669393] Fri, 20 April 2018 03:26 Go to previous messageGo to next message
cookiemonster
Messages: 13120
Registered: September 2008
Location: Rainy Manchester
Senior Member
Why are you opening any of them in serializable?
Re: Form Displaying Old version of data [message #669395 is a reply to message #669394] Fri, 20 April 2018 04:42 Go to previous messageGo to next message
manyal
Messages: 84
Registered: March 2005
Member
Because some forms are based on views not on table, where we have to set the isolation mode "serializable" than only it works.
Re: Form Displaying Old version of data [message #669396 is a reply to message #669395] Fri, 20 April 2018 05:00 Go to previous messageGo to next message
cookiemonster
Messages: 13120
Registered: September 2008
Location: Rainy Manchester
Senior Member
Setting serializable should make no difference to that.
Re: Form Displaying Old version of data [message #669431 is a reply to message #669396] Sun, 22 April 2018 23:56 Go to previous messageGo to next message
manyal
Messages: 84
Registered: March 2005
Member
I had to update the form with data source as view based on multiple tables, that i have done using on-update trigger while updating the form, that requires form to be in serialazable mode.
Re: Form Displaying Old version of data [message #669442 is a reply to message #669431] Mon, 23 April 2018 03:03 Go to previous messageGo to next message
cookiemonster
Messages: 13120
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try creating an instead of trigger on the view itself to update all the base tables.
Re: Form Displaying Old version of data [message #669461 is a reply to message #669442] Tue, 24 April 2018 00:48 Go to previous message
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'
Previous Topic: urdu language
Next Topic: Open URL in selected browser
Goto Forum:
  


Current Time: Sat May 26 01:31:19 CDT 2018