RE: how to make a delete statement fail

If execution plan uses index for criteria do an alter index xyz unusable, assuming skip_unusable_indexes is false (don't do this if this is a multi-billion row table ;-))    

Larry G. Elkins  

Joe Smith wrote:

How do I make a correct DELETE statement fail? I have a developer that wants to test a code branch and he needs a delete statement to fail.  

It can't be locked ( shared or exclusive ) from a separate session or be an incorrect statement or return "0 rows deleted."  

It has to be "delete from table where col = value". How can I force that to fail?    

 thanks.      

Windows Live: Keep your friends up to date with what you do online. Find out more.
<http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:O N:WL:en-US:SI_SB_online:082009>

--
http://www.freelists.org/webpage/oracle-l