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

ORA-37011: (XSACQUIRE_LOCKED) Object workspace object is locked by another user.

1 Answers  


ORA-09743: smscre: could not attach shared memory.

1 Answers  


ORA-07417: sfareq: One or more database writers not active.

1 Answers  


ORA-00113: protocol name string is too long

1 Answers  


ORA-22612: TDS does not describe a collection TDS

1 Answers  






PLS-00625: PARTITION/CLUSTER/ORDER-BY clause can only be used with IN parameters

1 Answers  


TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX

1 Answers  


PCC-02101: Unable to open input file

1 Answers  


ORA-29514: class name contains illegal character

1 Answers  


ORA-30757: cannot access type information

1 Answers  


ORA-00337: log file 'string' does not exist and no size specified

1 Answers  


ORA-06318: IPA: Local maximum number of connections exceeded

1 Answers  


Categories