Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00384: type mismatch found at 'string' in UPDATE's SET
clause



PLS-00384: type mismatch found at 'string' in UPDATE's SET clause..

Answer / guest

Cause: The column to the left of the equal sign in the SET
clause of an UPDATE statement does not match in datatype
with the column, expression, or subquery to the right of the
equal sign, and it is unclear which implicit conversion is
required to correct the mismatch.

Action: Change the expressions so that their datatypes
match. You might want to use datatype conversion functions
in the SET clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13359: extent does not have an area

1 Answers  


ORA-02768: Maximum number of files is invalid

1 Answers  


ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

2 Answers  


NNL-00510: Adds a data record to an existing name

1 Answers  


ORA-26050: Direct path load of domain index is not supported for this column type.

1 Answers  






ORA-06956: Failed to get local host name

1 Answers  


VID-00705: unsupported input format

1 Answers  


PLS-00485: in exception handler, 'string' must be an exception name

1 Answers  


NZE-29226: No matching private key found.

1 Answers  


NNL-00526: Starts a server using a non-standard executable and optional arguments

1 Answers  


RMAN-06544: Do you really want to delete the above objects (enter YES or NO)?

1 Answers  


RMAN-06144: FROM or UNTIL may not be specified with LIST INCARNATION

1 Answers  






Categories