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-16951: Too many bind variables supplied for this SQL statement.

1 Answers  


ORA-32841: invalid value for property string

1 Answers  


ORA-01681: max # extents (string) reached in LOB segment in tablespace string

1 Answers  


ORA-07563: sldext: $PARSE failure

1 Answers  


ORA-25287: Invalid value string, string should be non-negative

1 Answers  






LPX-00322: A doc referred by XSLT stylesheet could not be opened : ~s

1 Answers  


ORA-22920: row containing the LOB value is not locked

1 Answers  


ORA-25471: attribute name not specified for variable: string

1 Answers  


ORA-27075: SSTMOFRC constant too large

1 Answers  


NNL-00528: [set] password <password> : set the password for subsequent calls

1 Answers  


PLS-00260: Datetime/Interval constraints must be in range (0 .. 9)

1 Answers  


ORA-09750: pw_attachPorts: port_rename failed.

1 Answers  


Categories