E-AD: Following Peopletools 8.55 Upgrade "Find In" Function Throws "ORA-00932: inconsistent datatype: expected CHAR got LONG" Error
(Doc ID 2181597.1)
Last updated on APRIL 04, 2025
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.55 and laterInformation in this document applies to any platform.
Symptoms
When attempting to find a phrase "COBOL" in entire database using Application Designer's Find In feature the following error occurs.
ERROR
-----------------------
File: E:\pt855-903-R1-retail\peopletools\src\pside\PSFindInDlg.cppSQL error. Stmt #: 4669 Error Position: 143 Return: 932 - ORA-00932: inconsistent datatype: expected CHAR got LONG
Failed SQL stmt: SELECT COUNT(*) FROM PSPCMTXT P ,PSRECDEFN D WHERE P.OBJECTID1 = :1 AND P.OBJECTVALUE1 = D.RECNAME AND D.RECTYPE IN ( 0,1,2,3,5,6,7) AND UPPER(PCTEXT) LIKE UPPER('%COBOL%')
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Application Designer.
2. Click on Edit>FindIn
3. Enter COBOL under Find What and Project as Entire Database and Find Type as Text in PeopleCode and SQL.
4. Click on Find.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |