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

DRG-11711: too much data for term string

1 Answers  


ORA-32339: cannot alter materialized view with the PMOP

1 Answers  


QSM-01621: join backs to base tables not allowed with an equivalence

1 Answers  


ORA-28175: incorrect certificate type

1 Answers  


TNS-01414: "string", state string, established string, refused string, current string, max string

1 Answers  






CLSS-02203: unable to access voting device: string

1 Answers  


ORA-29504: invalid or missing schema name

1 Answers  


ORA-30687: session terminated by debugger

1 Answers  


ORA-02783: Both post and wait functions were not specified

1 Answers  


DRG-51301: error releasing dml Queue lock

1 Answers  


DRG-50920: part of phrase not itself a phrase or equivalence

1 Answers  


ORA-37100: (XSUNCOMMITTED) You have one or more updated but uncommitted analytic workspaces.

1 Answers  


Categories