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