1 Reply Latest reply on Jul 15, 2008 10:14 AM by 502182

    Warning: Procedure created with compilation errors.

    640250
      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;