Oracle End of file when executing procedure

1

I'm having the following error message when executing this procedure

*Encontrado simbolo "end of file" quando era esperado:*

DECLARE
  -- LOCAL VARIABLES HERE
  I INTEGER;
BEGIN

  FOR NCM IN (SELECT * FROM NCM_NCM) LOOP

    UPDATE ADMPRODU A
       SET A.CCNCMPRODU = NCM.NCM_NOVO
     WHERE A.CCNCMPRODU = NCM.NCM_VELHO

  END LOOP

END;
    
asked by anonymous 04.04.2017 / 18:53

1 answer

1

There are two left;

Look like this:

DECLARE
  -- LOCAL VARIABLES HERE
  I INTEGER;
BEGIN

  FOR NCM IN (SELECT * FROM NCM_NCM) LOOP

    UPDATE ADMPRODU A
       SET A.CCNCMPRODU = NCM.NCM_NOVO
     WHERE A.CCNCMPRODU = NCM.NCM_VELHO;

  END LOOP;

END;
    
04.04.2017 / 19:39