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
3203 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-23345: table "string"."string" not registered to collect statistics

1 Answers

ORA-08437: invalid picture type in picture mask

1 Answers

PCC-01401: Your Pro*Pascal authorization is about to expire

1 Answers

ORA-24411: Session pool already exists.

1 Answers

NZE-28806: Cannot write to the data source.

1 Answers

DRG-51301: error releasing dml Queue lock

1 Answers

SQL*Loader-00704: Internal error: string [number]

1 Answers

ORA-31077: invalid attribute "string" specified

1 Answers

NNO-00610: detected possible alias loop involving name "string"

1 Answers

ORA-19701: device name exceeds maximum length of string

1 Answers

ORA-38702: Cannot update flashback database log file header.

1 Answers

ORA-28667: USING INDEX option not allowed for the primary key of an IOT

1 Answers

For more Oracle Errors Interview Questions Click Here