Oracle Error PLS-00490: illegal statement

Oracle Error Message

PLS-00490: illegal statement

Reason for the Error

A constant, variable, function call, or incomplete statement was used where a statement was expected. For example, instead of calling a function from an expression, it might have been called as a statement (as if it were a procedure).

Solution

Check the statement, making sure that its commands, identifiers, operators, delimiters, and terminator form a complete and valid PL/SQL statement.