PLS-00381: type mismatch found at 'string' between column
and variable in subquery or INSERT



PLS-00381: type mismatch found at 'string' between column and variable in subquery or INS..

Answer / guest

Cause: The datatypes of a column and a variable do not
match. The variable was encountered in a subquery or INSERT
statement.

Action: Change the variable datatype to match that of the
column.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09790: sllfcf: unable to close file.

1 Answers  


PCB-00631: Host variable is not an External LOB

1 Answers  


ORA-13189: recursive SQL parse failed

1 Answers  


NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded

1 Answers  


DRG-13006: sub lexer for this language is not defined

1 Answers  






ORA-01769: duplicate CLUSTER option specifications

1 Answers  


ORA-19809: limit exceeded for recovery files

1 Answers  


ORA-01606: gc_files_to_locks not identical to that of another mounted instance

1 Answers  


ORA-33458: (ESDREAD09) Discarding compiled code for workspace object because number is now type string, whereas it was type string when the code was compiled.

1 Answers  


ORA-10648: Tablespace SYSAUX is not offline

1 Answers  


ORA-30075: TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint

1 Answers  


NNL-00409: data type is "string"

1 Answers  


Categories