Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> [Q] "PL/SQL Check #504" 어떤 에러인지...
Oracle 7.3.3의 DB에 Forms V4.5를 사용하고 있습니다. PL/SQL Editor에서 다음과 같이 Procedure를 작성하였는데 다음 diameter 와 관련된 column을 추가하였더니 다음과 같은 에러가 나오는군요.
PROCEDURE p_show_rolld_p IS
akt_stand_id NUMBER;
roll_roughness NUMBER;
roll_diameter NUMBER; <---BEGIN
BEGIN SELECT roll_id, roughness, diameter <--- INTO :bl_fv_rolld_p.us_roll_id, roll_roughness, roll_diameter <--- FROM fv_rolld WHERE stat = 'P' AND roll_pos = 'U' AND stand_id = akt_stand_id AND roll_type = 'BUR';
:bl_fv_rolld_p.us_roughness := fl_num_to_char( roll_roughness,
'0.00' );
:bl_fv_rolld_p.us_diameter := fl_num_to_char( roll_diameter,
'9990.00' ); <--- EXCEPTION WHEN NO_DATA_FOUND THEN
:bl_fv_rolld_p.us_roll_id := NULL;
:bl_fv_rolld_p.us_roughness := NULL;
:bl_fv_rolld_p.us_diameter := NULL; <----
END; IF akt_stand_id < 5 THEN NEXT_RECORD;