IF in_count < 20 THEN
ln_sql := 'SELECT superior_dev_type,superior_dev_id,superior_res_id '||
' FROM tel_res_localres_rel_'||in_bureau_id||
' WHERE subordinate_dev_type = '||in_sub_dev_type||
' AND subordinate_dev_id = '||in_sub_dev_id||' AND subordinate_res_id = '||in_sub_res_id||
' AND ROWNUM = 1';
BEGIN
EXECUTE IMMEDIATE ln_sql INTO ln_super_dev_type,ln_super_dev_id,ln_super_res_id; 这句中如果从in_sql中查出多条记录,会报异常
EXCEPTION
WHEN NO_DATA_FOUND THEN
IF in_count > 0 THEN
RETURN;
ELSE
RAISE;
END IF;
END;
ln_sql := 'SELECT superior_dev_type,superior_dev_id,superior_res_id '||
' FROM tel_res_localres_rel_'||in_bureau_id||
' WHERE subordinate_dev_type = '||in_sub_dev_type||
' AND subordinate_dev_id = '||in_sub_dev_id||' AND subordinate_res_id = '||in_sub_res_id||
' AND ROWNUM = 1';
BEGIN
EXECUTE IMMEDIATE ln_sql INTO ln_super_dev_type,ln_super_dev_id,ln_super_res_id; 这句中如果从in_sql中查出多条记录,会报异常
EXCEPTION
WHEN NO_DATA_FOUND THEN
IF in_count > 0 THEN
RETURN;
ELSE
RAISE;
END IF;
END;