Okay, we have a request worflow with the SQL below as it's first node:
SELECT NVL(supervisor_id,0) AS supervisor_id, CASE
WHEN supervisor_id is null THEN '311' ELSE ''
END IS_SUP_UPDATED from T_MASTER_ENTERPRISE_USERS
WHERE user_id = '${access_request_cri_meu_userId}'
Before patch 13, everything worked FINE. Now we get this error:
nested exception is: java.sql.SQLException: ORA-00933: SQL command not properly ended Error occurred in Statement #1 in Script ID 17:WPDS, Script Name = 'SQL Query', Script type = 'Action'. Job ID = 170625:WPDS, Process Ref = 'WF_RR_8900', Node Name = 'Null Supervisor', WorkItem = 1034344:WPDS:1
What are the NEW rules around single quotes?
We know that USER_ID is a NUMBER in the master users table. So WHY when I remove the single quotes from the where clause does it break?
Is it because of the VIA parameter right there? Will the SQL processor just plain not save that?
What gives?
I believe the issue is that we now keep the quotes as literal quotes that are concatenated to the variable value.
So - If we start with ‘${x}’
I am working on changing the processing as follows: