PLS Database Error Messages

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

oracle

PLS-00518: This INSERT statement requires VALUES clause containing a parenthesised list of values
Cause: 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);
 Action: Rewrite the statement to include a list of SQL data items in parentheses.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/