E-AD: Validate Syntax Fails for SQLs using Meta-SQL Elements such as %Select (Doc ID 2193483.1)

Last updated on OCTOBER 14, 2016

Applies to:

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

Symptoms

When using Meta-SQL such as %Select in the Application Designer SQL Editor, and one tries to validate the SQL, errors would occur:

MS SQL Server platform:

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '%'.
Error executing prepare

Oracle platform:

Error(8) 911: ORA-00911: invalid character

Sample Replication Steps:

1. Launch App Designer
2. File > New Definition > SQL
3. Copy & paste the below into the SQL Editor

4. Click the Validate button
5. Error occurs



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