Oracle Error PLS-00518: This INSERT statement requires VALUES clause containing a parenthesised list of values

Oracle Error Message

PLS-00518: This INSERT statement requires VALUES clause containing a parenthesised list of values

Reason for the Error

A VALUES clause was entered without a list of SQL data items in parentheses. In all INSERT statements with an explicit column list, the VALUES clause must contain a list of SQL data items in parentheses. For example: INSERT INTO my_tab (a,b,c) VALUES (1,2,my_variable);

Solution

Rewrite the statement to include a list of SQL data items in parentheses.