Example - Open Connection Command Block

Here is an example of using an open connection command block to set French as the language for an Oracle connection.

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