E-AE: 'ORA-00911: Invalid Character' error when compiling an AE SQL statement in App Designer
(Doc ID 2307710.1)
Last updated on JULY 21, 2020
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
On : 8.55.14 version, Application Engine
Invalid character error when compiling an existing AE SQL statement
Error(8) 911: ORA-00911: invalid character when attempting to compile an existing AE SQL statement
%Bind() is PeopleSoft meta-SQL function that App Designer compiler should replace before having Oracle validate the SQL.
This worked in 8.54, but the issue can be reproduced with the following steps in 8.55.14:
1. Navigate to Application Designer
2. Attempt the following SQL:
SET NG_BUDGET_AMT = 0
WHERE BUDGET_ID = %Bind (BUDGET_ID)
3. Error results
Error(8) 911: ORA-00911: invalid character
Error executing prepare.
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