Skip to main content
Question

ORA-00932:Inconsistent datatype while updating Table

J
Do Gooder (Partner)
Forum|alt.badge.img+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
Superhero (Employee)
Forum|alt.badge.img+28
  • Shneor Cheshin
  • Superhero (Employee)
  • 1138 replies
  • May 18, 2022

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
Sidekick (Employee)
Forum|alt.badge.img+8
  • Abhinavc
  • Sidekick (Employee)
  • 35 replies
  • May 23, 2022

 @Shneor did you face this issue

A
Sidekick (Partner)
Forum|alt.badge.img+8
  • AndreiaLeitao
  • Sidekick (Partner)
  • 32 replies
  • July 8, 2022

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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings