E-AD: 'Find In' Feature In Application Designer Gives SQL Error When Searching for Single Quote ' Characters
(Doc ID 2251256.1)
Last updated on NOVEMBER 23, 2019
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.55 [Release 8.4]Information in this document applies to any platform.
Symptoms
Find in in Application Designer doesn't work if search string has Single quotes. For example: if you try to search for hard coded value of 'test, you will get the following error.
File: E:\pt856-107-R1-debug\peopletools\src\pside\PSFindInDlg.cppSQL error. Stmt #: 4669 Error Position: 28 Return: 8012 - Invalid syntax in SQL statement 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('%'test%')
Similarly, on the Oracle platform:
File: E:\pt85510b-retail\peopletools\src\pside\PSFindInDlg.cppSQL error. Stmt #: 4669 Error Position: 165 Return: 907 - ORA-00907: missing right parenthesis
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('%'test%')
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('%'test%')
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 |