Example - Close Connection Command Block

Here is an example of using a close connection command block to re-set the language to English before disconnecting from an Oracle database.

<commandBlock> 
  <commands> 
   <sqlCommand> 
    <sql>ALTER SESSION SET NLS_LANGUAGE = ENGLISH</sql> 
   </sqlCommand> 
  </commands> 
</commandBlock>