My Oracle Support Banner

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 FEBRUARY 12, 2018

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.