Question

ORA-00932:Inconsistent datatype while updating Table

J
Rank
Userlevel 2
Badge +6

Hello all, 

We were trying to update a field on table C_TASK_EXTENSION (an extension of Task table) and we got the following error:

 

After some explorations, we noticed that this error only occurred when we had a field of the type Longstring populated:

 

 

However for example, if we try to update in other table some field when that entry has already a longstring field populated the error does not happen (for example when updating ADDRESS with COMMENTS field populated and also updating a custom table).

 

Has anyone faced this issue before?

 

Kind Regards, 

Joana Machado

3 replies

Shneor Cheshin
Rank
Userlevel 6
Badge +26

This requires a bit more investigation.

Try running the command 

desc MY_TABLE

And find the the type defined in the DB.

Another option is, re-create the custom metadata which might have been stored wrongly.

Delete the column and add it back again.

Cheers!

A
Rank
Userlevel 3
Badge +8

 @Shneor did you face this issue

A
Rank
Userlevel 4
Badge +8

Hi Community,

 

as a work around, we tried to change the type from Longstring to String. 

We’ve changed the type in custom metadata, generated the alter script from the menu but when running we get the following error:

 

Do you have any feedback on this behavior?

 

Thank you in advance,

Best Regards,

Andreia Leitão 

 

Reply


Terms & ConditionsCookie settings