SELECT return rows, but UPDATE using same WHERE conditions: 0 rows updated
20714Feb 13 2006 — edited Feb 15 2006Hi,
I got a question regarding the update:
got a table orderdetail, owner is wh3, now is using wh3 log in to SQL plus.
SQL> desc orderdetail;
Name Null? Type
----------------------------------------- -------- ----------------------------
SERIALKEY NOT NULL NUMBER
WHSEID VARCHAR2(30)
ORDERKEY NOT NULL VARCHAR2(10)
ORDERLINENUMBER NOT NULL VARCHAR2(5)
ORDERDETAILSYSID NUMBER(10)
EXTERNORDERKEY NOT NULL VARCHAR2(32)
EXTERNLINENO NOT NULL VARCHAR2(10)
SKU NOT NULL VARCHAR2(50)
STORERKEY NOT NULL VARCHAR2(15)
MANUFACTURERSKU NOT NULL VARCHAR2(50)
RETAILSKU NOT NULL VARCHAR2(50)
ALTSKU NOT NULL VARCHAR2(50)
ADDWHO NOT NULL
VARCHAR2(50)
SQL> select count(*) from orderdetail where orderkey='0000000168';
COUNT(*)
----------
26
SQL> update orderdetail set addwho='aaa' where orderkey='0000000168';
0 rows updated.
I checked it is not Lock and read only problem, anybody can help me to solve it?
Meanwhile, ORDERKEY+ORDERLINENUMBER = Primary Key.
There is a trigger related with SERIALKEY, just for new inserted record, the SERIALKEY will add 1 automatically.
Regards,
Jacky