Oracle End of file when running

Asked

Viewed 340 times

1

I’m getting the following error message when running this trial

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

1 answer

1


Two more to go ;

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

Browser other questions tagged

You are not signed in. Login or sign up in order to post.