PLS-00395: wrong number of values in VALUES clause of INSERT
statement



PLS-00395: wrong number of values in VALUES clause of INSERT statement..

Answer / guest

Cause: The number of columns in an INSERT statement does not
match the number of values in the VALUES clause. For
example, the following statement is faulty because no column
is specified for the value 20: INSERT INTO emp (empno,
ename) VALUES (7788, 'SCOTT', 20);

Action: Change the number of items in the column list or the
number of items in the VALUES list so that the numbers match.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-01160: Trace level was not specified

1 Answers  


ORA-30552: The package/procedure/function cannot be changed

1 Answers  


ORA-07601: spguno: $GETJPIW failure

1 Answers  


ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value

1 Answers  


ORA-01334: invalid or missing logminer dictionary processes context

1 Answers  






ORA-07205: slgtd: time error, unable to obtain time.

1 Answers  


ORA-21702: object is not instantiated or has been de-instantiated in cache

1 Answers  


ORA-02039: bind by value is not allowed for array type

1 Answers  


DRG-13008: cannot remove the DEFAULT sub lexer

1 Answers  


NNL-00260: Server-generated requests now do not require authoritative answers

1 Answers  


ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL

1 Answers  


ORA-32808: message system link string does not exist

1 Answers  


Categories