PLS-00381: type mismatch found at 'string' between column and variabl

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

Question Posted / guest

1 Answers
3041 Views
I also Faced
E-Mail Answers

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

KUP-04044: error positioning file string

1 Answers

NNO-00852: failed to get LDAP entry: error = number

1 Answers

ORA-14124: duplicate REVERSE clause

1 Answers

NZE-28779: no data access method specified in parameter

1 Answers

ORA-01283: Options specified is invalid

1 Answers

ORA-06814: TLI Driver: the SPX device file could not be opened

1 Answers

ORA-16953: Type of SQL statement not supported.

1 Answers

PCC-02449: Cannot type equivalence a UCS2 type

1 Answers

ORA-12413: labels do not belong to the same policy

1 Answers

LSX-00156: type is final and no derivations are allowed

1 Answers

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

1 Answers

DRG-11213: CTXSYS does not own procedure filter stored procedure: string

1 Answers

For more Oracle Errors Interview Questions Click Here