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

IMP-00089: Fine grain policy "string" not recreated on table/view "string"

1 Answers  


ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.

1 Answers  


NNL-00935: Requests refused, SINGLE-VALUE violation: number

1 Answers  


ORA-32139: Cannot write to the stream

1 Answers  


RMAN-07522: CREATE TYPE privilege must be granted to user string

1 Answers  






ORA-12686: Invalid command specified for a service

1 Answers  


ORA-32615: incorrect use of MODEL IS ANY predicate

1 Answers  


ORA-01668: standby database requires DROP option for offline of data file

1 Answers  


ORA-06922: CMX: bad write length

1 Answers  


KUP-04026: field too long for datatype

1 Answers  


KUP-03003: absolute end(number) - start(number) != fieldlength (number) for field string

1 Answers  


ORA-38749: A media recovery has been started.

1 Answers  


Categories