This discussion is archived
1 Reply Latest reply: Jul 15, 2008 3:14 AM by 502182 RSS

Warning: Procedure created with compilation errors.

640250 Newbie
Currently Being Moderated
Hi All,
I am creating a procedure to update the table, but i am getting following error
Warning: Procedure created with compilation errors.

code for my procedure is as follows

CREATE OR REPLACE PROCEDURE SP_UPDATE_MYT1
(
pEMPNO VARCHAR2(10),
pEMPNAME VARCHAR2(50),
pDEPTNO VARCHAR2(10)
)
AS
BEGIN
UPDATE MYT1 SET
EMPNAME=pEMPNAME, DEPTNO=pDEPTNO WHERE EMPNO=pEMPNO;
COMMIT;
END;