title: How to know whether SQL is successfully executed when programming using Pro*C?
body: <p>I recently programme using Pro*C to access Oracle database like this:</p>
  
  <pre><code>cmd[128];
  dpc_set_sqlca(&amp;sqlca);
  strcpy(cmd,"EXECUTE IMMEDIATE");
  dpc_exec_immediate(sql_string);
  SQLCODE = sqlca.sqlcode;
  </code></pre>
  
  <p>How to know whether the SQL has successfully executed?</p>
  
  <p>For example, how to know whether a table exists in oracle DB?
  How to know whether an <code>INSERT</code> statement is successfully executed?</p>