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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00498: illegal use of a type before its declaration

1 Answers  


LSX-00122: value is not valid restriction of parent's whiteSpace

1 Answers  


ORA-38702: Cannot update flashback database log file header.

1 Answers  


ORA-34000: (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object.

1 Answers  


ORA-30730: referential constraint not allowed on nested table column

1 Answers  


ORA-13528: name (string) is already used by an existing baseline

1 Answers  


SQL*Loader-00306: Token longer than max allowable length of number chars

1 Answers  


ORA-31451: invalid value string for capture_values, expecting: OLD, NEW, or BOTH

1 Answers  


ORA-29904: error in executing ODCIIndexClose() routine

1 Answers  


ORA-02257: maximum number of columns exceeded

1 Answers  


ORA-22952: Nested Table equality requires a map method on the element ADT

1 Answers  


ORA-19756: corrupt block number string found in change tracking file

1 Answers   Scope International,


Categories