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.

Hi,

I think that the table you are trying to delete is locked.
Check if the object is locked using the following SQL

SELECT b.object_name
FROM v$locked_object a,
all_objects b
WHERE a.object_id = b.object_id


Hope it Helps