Variable in the process tab of a Workflow with ":PSET &param# = ' '" will be saved as an empty string when using Oracle

Document ID : KB000087792
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

Setting a variable in the process tab of a Workflow when using an Oracle database with the following string: 
 
:PSET &param# = ' '

results in the following outcome.

Actual
The variable will be saved as an empty string '' in the task of the Workflow.

Expected
The variable result should be a blank and not an emtpy string.

 
Cause:
Cause type:
Defect
Root Cause: A value of a variable consisting of several blanks will be saved as an empty string when using an Oracle database.
Resolution:
Update to a fix version listed below.

Fix Status: Released

Fix Version(s):
Automation Engine 12.0 - Available
Automation Engine 11.2.3 - Available
Automation Engine 11.1.5 - Available
Additional Information:
Workaround :
N/A