Error ORA-00911: invalid character' for SQLI VARA

Document ID : KB000113133
Last Modified Date : 05/09/2018
Show Technical Document Details
Issue:
A Predefined System Variable (e.g. &$CLINET#) is used in an SQLI variable as in the example below. When you click Preview, the error is shown.
 
User-added image
Resolution:
Log in to Client 0. Open the system variable UC_SYSTEM_SETTINGS for editing and change that value of VAR_SECURITY_LEVEL to 3.