السلام عليكم
ما المشكة في هدا الكود
ما هو الخطاء عند تكوين ال Function
CREATE OR REPLACE TYPE SOCtype1 AS OBJECT (
soc1 char(3),
FINAL MEMBER FUNCTION soc2(t_no IN NUMBER) RETURN NUMBER
) NOT FINAL;
/
CREATE OR REPLACE TYPE BODY SOCtype1 AS MEMBER FUNCTION soc2 (t_no number) RETURN NUMBER IS
v_a number(5);
Cursor cur_sample is Select S.a from SOCTABLE S Where S.soc1 = soc1;
BEGIN
open cur_sample; fetch cur_sample into v_a;
if t_no >= 4 then
RETURN v_a * 1000;
else
RETURN v_a * 500;
end if;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN 0;
WHEN OTHER THEN
RETURN 0;
END ;
/
SQL> show error
Errors for TYPE BODY SOCTYPE1:
LINE/COL ERROR
-------- -----------------------------------------------------------------
17/4 PLS-00103: Encountered the symbol "end-of-file" when expecting
one of the following:
end not pragma final instantiable order overriding static
member constructor map