Need to change JSON response

First, can I ask if there is a reason you are not using the Oracle Update snap?

If you do need to do this in the Execute snap, I would suggest that you not make the Statement property an expression since it is difficult to construct the statement correctly (as you have found out). You can do substitutions of values from the input document when the Statement is not a property by using a JSON-Path. So, you could put a Mapper before the Execute snap to generate the JSON string using an expression like the following:

JSON.stringify({TOTAL_CR_WRNO: $TOTAL_CREATED_WRNO})

If that expression was mapped to the output document as $xx_DOCUMENT, you can then reference it in the Execute snap’s Statement property like so:

UPDATE SMRT_TEST SET xx_DOCUMENT = $xx_DOCUMENT