My Oracle Support Banner

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

Last updated on NOVEMBER 23, 2019

Applies to:

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


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


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

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