PLS-00103: Encountered the symbol "end-of-file" in simple update block
You have a number of problems here:
Missing semi-colon (as MJB saw)
:ID
refers to an in-bound variable, so your local declaration (DECLARE ID NUMBER;
) is not being used.You're using a variable name which (apparently) is the same name as a colum in your table. If you try to use your local
ID
variable, the query will still not use it unless you use a block label.
That said, it looks like you're sending ID in as a bind variable anyway, so it's more likely that you should just remove the declaration from the block.
In addition to the previous you have to prevent spaces between equal operation ,:,and the value like this:
SQL> BEGIN 2 IF x > y THEN high := x; END IF; -- correct3 IF x > y THEN high := x; ENDIF; -- incorrect4 END;5 /END;
ERROR at line 4:ORA-06550: line 4, column 4:PLS-00103: Encountered the symbol ";" when expecting one of the following:if
visit the website to read more....https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/fundamentals.htm#LNPLS002