We upgraded to the Oracle SQL Developer version 21.4.0.346 recently, and now our queries towards DB2 no longer seem to function as they did in 3.2.20.09 ( I know, huge jump)
It appears that script execution is sending everything to DB2 rather than doing variable substitution as it did in the previous version, so it no longer allows DEFINE to work.
For example, I was formerly able to execute the below code.
DEFINE SVC_ID = '1234';
SELECT *
FROM DEV.TEST
WHERE S.SVC_ID = '&SVC_ID';
Is there a way to change this in settings?