PLS-00394: wrong number of values in the INTO list of a
FETCH statement



PLS-00394: wrong number of values in the INTO list of a FETCH statement..

Answer / guest

Cause: The number of variables in the INTO clause of a FETCH
statement does not match the number of columns in the cursor
declaration.

Action: Change the number of variables in the INTO clause or
the number of columns in the cursor declaration so that the
numbers match.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00629: PIPE statement cannot be used in non-pipelined functions

1 Answers  


ORA-24435: Invalid Service Context specified.

1 Answers  


ORA-30155: An I/O Error occured during an OCIFile function call

1 Answers  


TNS-01102: TNS application contacted was not the listener

1 Answers  


ORA-39705: component 'string' not found in registry

1 Answers  






ORA-30436: unable to open named pipe 'string'

1 Answers  


NNO-00255: cannot initialize ROS

1 Answers  


PCC-02369: An EXEC TOOLS host pointer variable is not a pointer

1 Answers  


TNS-00244: Connection Manager: Request Failed

1 Answers  


ORA-06144: NETTCP: SID (database) is unavailable

1 Answers  


ORA-03127: no new operations allowed until the active operation ends

1 Answers  


ORA-02784: Invalid shared memory ID specified

1 Answers  


Categories