title: Unable to execute "Commit" in ADODB.COMMAND
body: <p>I am running Excel VBA code which is connecting to an Oracle DB and ADODB. 
  I am able to connect to Oracle server using following Connection String:
  <code>dbConnectStr = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST='Host')(PORT='Port'))(CONNECT_DATA=(SERVICE_NAME='service')));Data Source='Source'; User Id='User';Password='Password"</code></p>
  
  <pre><code>With dbConnection
      .ConnectionString = dbConnectStr
      .Properties("Prompt") = adPromptNever
      .Open ConnectionString
  End With
  </code></pre>
  
  <p>I am able to execute Select Commands.</p>
  
  <p>But when I try to execute following SQL Update command which is followed by a "COMMIT", I get Oracle error : ORA-0091: invalid character. </p>
  
  <p>On omitting Commit, the error disappears. </p>
  
  <pre><code>   sSQL = "UPDATE EMPLOYEE SET DOJ ='31-DEC-9999' WHERE EMP_ID =55555; COMMIT;"
  
      With dbCommand
          .ActiveConnection = dbConnection
          .CommandText = sSQL
          .CommandType = adCmdUnknown
          .CommandTimeout = 600
      End With
  
      Set dbRecordset = dbCommand.Execute
  </code></pre>
  
  <p>Having "COMMIT" in the SQL is my integral requirement, which I can not ignore or replace with something else.</p>
  
  <p>Please help. Thanks in advance
  Sachin D</p>