My Oracle Support Banner

E-AE: %SqlHint Not Working and Errors Out With ' SQL Error: ORA-01742: comment not terminated properly' (Doc ID 2380902.1)

Last updated on FEBRUARY 08, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

Trying to add a hint within an AE program code using %SqlHint but the process is ending with error:

SQL Error: ORA-01742: comment not terminated properly

Example that fails with %SqlHint()

%SqlHint (UPDATE, 1, '/*+ INDEX_RS_ASC(PSDJRNL_LN) */'
UPDATE PS_%Bind(GL_JEDIT_WK_AET.RECNAME_JRNL_LN,NOQUOTES)
SET MONETARY_AMOUNT=%RoundCurrenty....
WHERE PROCESS_INSTANCE IN (%Bind(PROCESS_INSTANCE), %Bind(GL_JEDIT_WK_AET.PROCESS_INSTANCE2))
AND BUSINESS_UNIT=%Bind(GL_JEDIT_WK_AET.BUSINESS_UNIT)....

 

Environment:

FSCM 9.2.17, Tools 8.55.11 on Oracle 12.1.0.2











Changes

 

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
Changes
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.