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 NOVEMBER 23, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
When attempting to find a phrase "COBOL" in entire database using Application Designer's Find In feature the following error occurs.
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%')
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.
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