title: ORA:009955 error(Name is used by an existing object)
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5259351/name-already-used-by-an-existing-object-in-vba">Name already used by an existing object in VBA</a>  </p>
  </blockquote>
  
  
  
  <p>I am using Oradynaset object to fetch the results from data base in VBA but the same object i.e OraDynaset does not work to create new table as i use the following query</p>
  
  <p>strsql="create table abs.test as (select * from emp)"
  Oradynaset=objDatabase.DBCreatedynaset(strsql,o&amp;)</p>
  
  <p>after running this query i get the error - ORA 009955:Object is used by an existing object.</p>
  
  <p>can you please help me on this.</p>