E-AD: Following Peopletools 8.55 Upgrade "Find In" Function Throws "ORA-00932: inconsistent datatype: expected CHAR got LONG" Error
Last updated on FEBRUARY 12, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms