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
3117 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-27007: failed to open file

1 Answers

ORA-38473: cannot drop a type used for Expression Filter attribute set

1 Answers

ORA-28005: invalid logon flags

1 Answers

ORA-25182: feature not currently available for index-organized tables

1 Answers

SQL*Loader-00564: illegal hexadecimal literal specified for record delimiter

1 Answers

ORA-03007: obsolete feature

1 Answers

RMAN-06722: unable to remove file "string" from catalog

1 Answers

ORA-09840: soacon: Name translation failure.

1 Answers

LSX-00230: invalid integer "~S"

1 Answers

ORA-01649: operation not allowed with a backup controlfile

1 Answers

RMAN-06582: AS COPY option cannot be used when backing up backupsets

1 Answers

ORA-24196: access the message in a wrong access mode

1 Answers

For more Oracle Errors Interview Questions Click Here