oci_bind_by_name($stmt, ":error", $error, 3);
oci_bind_by_name($stmt, ":errorMsg", $errorMsg, 512);
oci_bind_by_name($stmt, ":result", $cursor, -1, OCI_B_CURSOR);
oci_execute($stmt);
if ($error != 0) {
    echo "<h2 class=\"erro\">Erro: {$errorMsg}</h2>";
} else {
    echo "\n<table> \n<tr>\n<th>Nome</th>\n<th>Data de Nascimento</th>\n<th>&nbsp;</th>\n</tr>";
    oci_execute($cursor);
    while ($result = oci_fetch_object($cursor)) {
        echo "\n<tr>\n<td>{$result->AUT_NOME}</td>\n<td>{$result->AUT_DT_NASC}</td>\n</tr>";
    }
    echo "</table>";
}
oci_free_statement($stmt);
oci_free_cursor($cursor);
oci_close($conn);
?>
 <div class="entry">
          <p class="links"><a href="#" class="more">Voltar ao início</a> &nbsp;&nbsp;&nbsp;</p>
        </div>
      </div>
 
      </div>
   
      </div>
    </div>
    <!-- start sidebars -->
     <div id="sidebar1" class="sidebar">
      <ul>
        <li>
Ejemplo n.º 2
0
 public function executeSql($sql, $array = null)
 {
     $cur = $this->getOci8Cursor($sql, $array);
     oci_free_cursor($cur);
     return true;
 }
Ejemplo n.º 3
0
 /**
  * close() only needs to be called if you are worried about using too much
  * memory while your script is running. All associated result memory for the
  * specified result identifier will automatically be freed.
  */
 function _close()
 {
     if ($this->connection->_stmt === $this->_queryID) {
         $this->connection->_stmt = false;
     }
     if (!empty($this->_refcursor)) {
         oci_free_cursor($this->_refcursor);
         $this->_refcursor = false;
     }
     @oci_free_statement($this->_queryID);
     $this->_queryID = false;
 }
Ejemplo n.º 4
0
 /**
  * Closes the cursor, enabling the statement to be executed again.
  *
  * @return bool TRUE on success or FALSE on failure.
  */
 public function closeCursor()
 {
     return oci_free_cursor($this->sth);
 }