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-31219: DBMS_LDAP: PL/SQL - Invalid LDAP notypes.

1 Answers  


DRG-12201: section group string already exists

1 Answers  


ORA-07254: spdcr: translation error while expanding ?/bin/oracle.

1 Answers  


ORA-39951: incomplete values specified for PL/SQL warning settings

1 Answers  


ORA-02719: osnfop: fork failed

1 Answers  


ORA-10567: Redo is inconsistent with data block (file# string, block# string)

1 Answers  


TNS-01417: "string" established:string refused:string state:string

1 Answers  


ORA-30054: invalid upper limit snapshot expression

1 Answers  


ORA-22973: size of object identifier exceeds maximum size allowed

1 Answers  


ORA-25446: duplicate column value for table alias: string, column: string

1 Answers  


QSM-00754: task string does not reference a valid workload and therefore cannot be executed

1 Answers  


ORA-04087: cannot change the value of ROWID reference variable

1 Answers  


Categories