Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
When I try to use TestVerdictName(LastResult()) in the Compuatation Definition of a custom field, I get the below error.
MKS131372: An unhandled database exception has occurred. Please contact your administrator. The error supplied by the database is: ORA-00932: inconsistent datatypes: expected CHAR got CLOB
If I just use ToText(LastResult()) then I can at least get the number value of the last result but as soon as I replace it with TestVerdictName I get this error. I think I understand what the error is saying but I don't understand why I'm getting it.
Currently I am trying to work through the embedded if statements. The field type is shorttext. The Computation Definition (which isn't complete) is:
isMeaningful() ?
(
IsEmpty(lastResult(), 99) == 99 ?
(
"ALM_Verified By Trace Count" > 0 ?
Text("Traces")
:
Text("Not Run")
)
:
TestVerdictName(LastResult())
)
: emptytext()
Solved! Go to Solution.
Hello Nolin,
This may be a product problem. Please contact PTC Integrity Support to open a ticket for this issue.
The error is happening because your backing Oracle database is expecting a CHAR type value for a method, and is instead getting a CLOB. The ORA-00932: inconsistent datatypes error comes up anytime this sort of situation occurs, and I doubt it is as a result of your computation definition, although I am not convinced about the results of the TestVerdictName(LastResult()) call..
Regards,
Kael
Hello Nolin,
This may be a product problem. Please contact PTC Integrity Support to open a ticket for this issue.
The error is happening because your backing Oracle database is expecting a CHAR type value for a method, and is instead getting a CLOB. The ORA-00932: inconsistent datatypes error comes up anytime this sort of situation occurs, and I doubt it is as a result of your computation definition, although I am not convinced about the results of the TestVerdictName(LastResult()) call..
Regards,
Kael
Kael,
I will open a ticket. Thank you for the info.
Thanks,
Nolin