how to make a delete statement fail
- From: Joe Smith <joe_dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Aug 2009 20:20:41 -0500
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.
http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009
Other related posts:
