Oracle View causes stale data

[jh363]

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

[Adam Cameron.]

And do you see the same behaviour when running the process via Oracle

SQL Developer (or similiar)? Is there any reason to think this is a CF

issue, or is it an Oracle issue? Is it a view or a materialized view?

--

Adam

[jh363]

Thanks, I found the problem...it was a pilot error.  The View was NOT pointed to the same table as the update .  Could you please have a peek at my other question logged the same day as this one?