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

RMAN-05009: Block Media Recovery requires Enterprise Edition

1 Answers  


SQL*Loader-00906: Error executing SQL statement for upi: [number]

1 Answers  


ORA-23348: cannot replicate procedure string; only IN parameters supported

1 Answers  


ORA-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [inhierarchy {variable | valueset}].

1 Answers  


QSM-00753: the specified value string is out of the acceptable range of string to string for parameter string

1 Answers  






ORA-02184: resource quotas are not allowed in REVOKE

1 Answers  


RMAN-06711: global scripts require a target connection

1 Answers  


ORA-09701: scnfy: maximum number of processes exceeded

1 Answers  


ORA-31105: User does not own lock "string"

1 Answers  


NZE-28844: No wallet present

1 Answers  


TNS-00528: Protocol Adapter not loaded

1 Answers  


ORA-24787: remote cursors must be closed before a call completes

1 Answers  


Categories