----- Original Message ----- From: "Mark W. Farnham" <mwf@xxxxxxxx> To: <jonathan@xxxxxxxxxxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, September 11, 2012 3:08 PM Subject: RE: Function Based Index |I look forward to Jonathan's posting. In the meantime, it seems likely to me | the bug will not exhibit if you rework the code as | Done, http://jonathanlewis.wordpress.com/2012/09/11/fbi-delete/ I can't claim that it explains this specific example - but it certainly look relevant and may give some clues. Regards Jonathan Lewis http://jonathanlewis.wordpress.com/all_postings Author: Oracle Core (Apress 2011) http://www.apress.com/9781430239543 -- //www.freelists.org/webpage/oracle-l