Oracle View causes stale data
I noticed my List page displays stale data after Updates if my list select is based on an Oracle View object, whereas if I change the select to go directly at the Table then the list is accurate. For example, say I drill-down on record 1 in the list and then edit the Description...next I Save the edit and the UI returns to the List page. But, the List page still shows the "old" Description. If I drill-down again, I see the "updated" Description (or if I connect to the db using another client I have verified the update was indeed successful).
So, why would using an Oracle View have this negative behavior and is there a way to correct this...since using Views are considered a Best Practice. Here's the query:
<cfquery
datasource="BIDW_QDM" name="listDS">select * from v_opn_incdt_tckt_jh363x</cfquery>
<cfquery
dbtype="query" name="listQ">select * from listDS</cfquery>
...
<cfoutput
query="listQ">
...
Thanks,
J
