Select Charge_ID into ChargeID,FaultType_Name into FaultTypeName ***** from t_fault_type where FaultType_ID = ChargeID; -> Select Charge_ID, FaultType_Name into ChargeID,FaultTypeName ***** from t_fault_type where FaultType_ID = ChargeID; 你的while好象是个死循环,你检查一下
while ChargeID is not null loop Select Charge_ID into ChargeID,FaultType_Name into FaultTypeName ***** from t_fault_type where FaultType_ID = ChargeID; end loop; --改為 while ChargeID is not null loop Select Charge_ID,FaultType_Name into ChargeIDinto ,FaultTypeName ***** from t_fault_type where FaultType_ID = ChargeID; end loop;
from t_fault_type
where FaultType_ID = ChargeID; -> Select Charge_ID, FaultType_Name into ChargeID,FaultTypeName *****
from t_fault_type
where FaultType_ID = ChargeID; 你的while好象是个死循环,你检查一下
loop
Select Charge_ID into ChargeID,FaultType_Name into FaultTypeName *****
from t_fault_type
where FaultType_ID = ChargeID;
end loop;
--改為
while ChargeID is not null
loop
Select Charge_ID,FaultType_Name into ChargeIDinto ,FaultTypeName *****
from t_fault_type
where FaultType_ID = ChargeID;
end loop;