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 SEPTEMBER 11, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms