Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL script error
Can anyone find what is giving me this error:
DECLARE
*
ERROR at line 1:
ORA-02049: timeout: distributed transaction waiting for lock
ORA-06512: at line 15
Here is my script, if I substitute an actual product # for the 2 v_tdrow.prod's and make the cursor only fetch one row, it works, so I think something is wrong with the way I'm doing the cursor or using it.
DECLARE
v_tdrow prdinfo.qty_sold%type;
CURSOR info IS
select distinct prod_id as prod_id from order_in_detail;
BEGIN
OPEN info;
LOOP
FETCH info INTO v_tdrow; EXIT WHEN info%NOTFOUND; UPDATE prdinfo set qty_sold=(select sum(order_qty) fromorder_in_detail where prod_id=v_tdrow.prod_id) where prod_id=v_tdrow.prod_id;
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Sep 09 1999 - 08:32:22 CDT