Something really strange is happening (Oracle 8i). I have a database and when i try to delete a record which doesn´t exist the sqlplus becomes locked. And other tables the sqlplus returns the correct message "0 rows deleted". i.e: table home -------------------------------- | id(Integer) | address(String) | -------------------------------- | 1 | addr1 | | 2 | addr2 | | 3 | addr3 | --------------------------------
When i try: "delete from home where id = 5" the SQLPlus locks!!! What is going on? Could it be the relashionship between tables? tks, Carlos. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4