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-31438: duplicate change table string

1 Answers  


ORA-03241: Invalid unit size

1 Answers  


ORA-01536: space quota exceeded for tablespace 'string'

3 Answers   Bloom Soft Tech, TCS,


ORA-06790: TLI Driver: poll failed

1 Answers  


ORA-25534: _MEAN_TIME_TO_CLUSTER_AVAILABILITY is specified

1 Answers  






ORA-07477: scgcmn: lock manager not initialized.

1 Answers  


LSX-00014: empty instance document

1 Answers  


ORA-25225: invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED

1 Answers  


ORA-07550: sftopn: $CONNECT failure

1 Answers  


TNS-01402: TYPE: string

1 Answers  


LSX-00210: value "~1S" out of range for type "~2S"

1 Answers  


ORA-30036: unable to extend segment by string in undo tablespace 'string'

1 Answers  


Categories