Is it possible to reference a published parameter in an Oracle Writer SQL Statement To Execute Before Translation parameter? This is what I've tried, with no success:
delete from CMSS.STAGE_ASSET_INFO
where CMSS.STAGE_ASSET_INFO.ASSET_ID='$(assetId)'
commit
This is the error from the log file:
|ERROR |Execution of statement `delete from CMSS.STAGE_ASSET_INFO
where CMSS.STAGE_ASSET_INFO.ASSET_ID='$(assetId)'
commit' did not succeed; error was `ORA-00933: SQL command not properly ended'. (serverType=`ORACLE8I', serverName=`distprod', userName=`CMSS_APP', password=`***', dbname=`')
This was the assetId parameter value in the test:
'assetId': 'Aab84eddc68f84ca1b211f993d5b8bf56'
Thanks,
Rob