Skip to main content
Participant
May 7, 2010
Question

Oracle View causes stale data

  • May 7, 2010
  • 1 reply
  • 902 views

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

    This topic has been closed for replies.

    1 reply

    Inspiring
    May 7, 2010

    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

    jh363Author
    Participant
    May 7, 2010

    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?