How to fix the Oracle error PLS-00518: This INSERT statement requires VALUES clause containing a parenthesised list of values?

In this post, you’ll learn more about the Oracle ErrorPLS-00518: This INSERT statement requires VALUES clause containing a parenthesised list of values with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error PLS-00518: This INSERT statement requires VALUES clause containing a parenthesised list of values ?

You can fix this error in Oracle by following the below steps

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