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
3131 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

ORA-01277: file 'string' already exists

1 Answers

ORA-32118: Cannot perform operation on a null FILE

1 Answers

ORA-13367: wrong orientation for interior/exterior rings

1 Answers

DRG-11619: URL store: row in table is empty

1 Answers

RMAN-06128: skipping inaccessible file string

1 Answers

RMAN-04025: unable to generate a temporary file

1 Answers

ORA-03201: the group number specification is invalid

1 Answers

NZE-29035: Pseudo Random Number Generator is needed

1 Answers

QSM-01004: no query rewrite before view merging

1 Answers

ORA-08315: sllfrb: Error reading file

1 Answers

LSX-00265: attribute "~1S" value "~2S" is wrong (must be "~3S")

1 Answers

DRG-13312: user CTXSYS does not own USER_LEXER stored procedure string

1 Answers

For more Oracle Errors Interview Questions Click Here