title: Error while executing SQL query in VBA
body: <p>I am getting error while executing below query in VB (I am using macro to run this query). But in ORACLE, the same query runs file and gives me the expected result.
  Please note that, "XML_FIELD" is a CLOB Which has XML Data in it. I am trying to extract data from "XML_FIELD" using VB Macro. </p>
  
  <p><strong>Query in SQL: executes fine :<br>
  ---> select xmltype(XML_FIELD).extract('//XML_TAGNAME/text()').getStringVal() as NEW_COL from TAB_1 where TEST_ID = 123</strong></p>
  
  <h2><em><strong>Error in VB: SQL Execution Error ora-00936 missing expression</em></strong></h2>
  
  <p><strong>Query in VBA:</strong><br>
  Sub Extract_CLOB()<br>
  Dim SQL As String<br>
  Dim OraDynaSet As Object<br>
  'Comment: I am using two single quotes (' ' ) to escape the other single quote<br>
  <strong>SQL = "select xmltype(XML_FIELD).extract(''//XML_TAGNAME/text()'').getStringVal() as NEW_COL from TAB_1 where TEST_ID = 123"</strong><br>
  Set OraDynaSet = objDataBase.DBCreateDynaset(SQL, 0&amp;)<br>
  End Sub</p>