Error ORA-00911: invalid character' for SQLI VARA

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.
 

<Please see attached file for image>

Environment

Release: AUTWAB99000-11.2-Automic Workload Automation-Base Edition
Component:

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.