A simple question!

abel63

Declare
hh dlyx.y_khda.hh% Type;
s Number: = 0;
Begin
For m In (Select * From tmhb070101 t)
Loop
Select Count (*)
Into s
From dlyx.y_khda@yjdlyx k Where
substr (k.yhh, 1, length (k.yhh) -3) = m.yhh And k.dw Like '0303%';
dbms_output.put_line (s);
If s = 1 Then
   Select k.hh
   Into hh
   From dlyx.y_khda@yjdlyx k Where
   substr (k.yhh, 1, length (k.yhh) -3) = m.yhh;
   dbms_output.put_line (hh);
   Update tmhb070101 tm
   Set tm.hh = hh
   Where tm.yhh = m.yhh;
End If;
End Loop;
Commit;
--Select * From tmhb070101;
End;
After I executed this procedure, why the field hh in the table tmhb070101 is still not updated.

我是杀人狂

If the statement is correct, it is that the IF statement has always returned false and the following statement has not been executed.

oly622

You put Select Count(*) From dlyx.y_khda@yjdlyx k Where
substr(k.yhh,1,length(k.yhh)-3)=m.yhh And k.dw Like '0303%' execute it, you seem to be accessing a table in another database, what is m? ?

abel63

Why didn't a kind person say it?

hzy520cf

The landlord check whether s = 1 has a chance to be established.
Check step by step to find the reason.

@yjdlyx Is this dblink? Is accessing a remote database?

abel63

The landlord check whether s = 1 has a chance to be established.
Check step by step to find the reason.
--Checked, there is a chance of establishment,
@yjdlyx Is this dblink? Is accessing a remote database?
--Yes