The table which I am accessing will be truncated and fresh data is loaded once in a day.No changes are made apart from that.Just to be sure that the previous cursor(if any) is not getting cached I restarted the db so that the cursor is flushed.But after accessing the cfm page 2-3 times, again the same error is popping up.
> Did you add/rename a table column or make a similar change after the > first time you ran this query? > > On 7/10/07, hussain shaikh wrote: > > I found on net that this ORA error is thrown when the cursor which > holds the query data gets invalidated i.e. the cursor is not in sync > with the table data. > > I am sure it has something to do with the behaviour/working of the > cfqueryparam tag. > > -- > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com. au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
