Last updated on FEBRUARY 04, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.40 and later
Information in this document applies to any platform.
***Checked for relevance on 20-AUG-2013***
***Checked for relevance on 04-FEB-2016***
When creating a PSQuery expression containing string literals that contain words coinciding with SQL reserved keywords such as FROM, etc., an error will be generated.
For example, the following expression:
WHEN A.AUDIT_ACTN = 'A' THEN 'Add '
WHEN A.AUDIT_ACTN = 'D' THEN 'Delete'
WHEN A.AUDIT_ACTN = 'C' THEN 'C(from)'
ELSE 'blah' END
will return an error "FROM clauses are not allowed in expressions."
How to use 'from' as a part of a string literal without getting that error?
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