السلام عليكم ما الخطا فى هذا PROCEDURE

[محمد سعيد]

CREATE OR REPLACE PROCEDURE XX(C IN EMP.EMPNO%TYPE)
IS
PROCEDURE ZZ;
IS
BEGIN
INSERT INTO LOG_TAB(USER_ID,LOGDATA)
VALUES(USER,SYSDATE);
END ZZ;

BEGIN
DELETE FROM EMP
WHERE EMPNO=C;
ZZ;
END XX;

[dubainet]

PROCEDURE ZZ;

it might be the semi-colun here

[abdelhay]

Remove the semi-colon after the text PROCEDURE ZZ; than it will be compile without any errors.

CREATE OR REPLACE PROCEDURE XX(C IN EMP.EMPNO%TYPE) IS
PROCEDURE ZZ
IS
BEGIN
INSERT INTO LOG_TAB(USER_ID,LOGDATA) VALUES(USER,SYSDATE);
END ZZ;

BEGIN
DELETE FROM EMP WHERE EMPNO=C;
ZZ;
END XX;