<div id="content"> <h1 align="center">Source for file Oracle.php</h1> <p>Documentation is available at <a href="../Doctrine/Doctrine_Adapter/_Doctrine---Adapter---Oracle.php.html">Oracle.php</a></p> <div class="src-code"><span class="php"> <ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li> <li><div class="src-line"><a name="a2"></a><span class="src-comm">/*</span></div></li> <li><div class="src-line"><a name="a3"></a><span class="src-comm"> * $Id: Mock.php 1080 2007-02-10 18:17:08Z romanb $</span></div></li> <li><div class="src-line"><a name="a4"></a><span class="src-comm"> *</span></div></li> <li><div class="src-line"><a name="a5"></a><span class="src-comm"> * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS</span></div></li> <li><div class="src-line"><a name="a6"></a><span class="src-comm"> * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT</span></div></li> <li><div class="src-line"><a name="a7"></a><span class="src-comm"> * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR</span></div></li> <li><div class="src-line"><a name="a8"></a><span class="src-comm"> * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT</span></div></li> <li><div class="src-line"><a name="a9"></a><span class="src-comm"> * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,</span></div></li> <li><div class="src-line"><a name="a10"></a><span class="src-comm"> * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT</span></div></li> <li><div class="src-line"><a name="a11"></a><span class="src-comm"> * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,</span></div></li> <li><div class="src-line"><a name="a12"></a><span class="src-comm"> * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY</span></div></li> <li><div class="src-line"><a name="a13"></a><span class="src-comm"> * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT</span></div></li> <li><div class="src-line"><a name="a14"></a><span class="src-comm"> * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE</span></div></li> <li><div class="src-line"><a name="a15"></a><span class="src-comm"> * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.</span></div></li> <li><div class="src-line"><a name="a16"></a><span class="src-comm"> *</span></div></li> <li><div class="src-line"><a name="a17"></a><span class="src-comm"> * This software consists of voluntary contributions made by many individuals</span></div></li> <li><div class="src-line"><a name="a18"></a><span class="src-comm"> * and is licensed under the LGPL. For more information, see</span></div></li> <li><div class="src-line"><a name="a19"></a><span class="src-comm"> * <http://www.phpdoctrine.com>.</span></div></li> <li><div class="src-line"><a name="a20"></a><span class="src-comm"> */</span></div></li> <li><div class="src-line"><a name="a21"></a><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><a href="../Doctrine/Doctrine.html#methodautoload">autoload</a><span class="src-sym">(</span><span class="src-str">'Doctrine_Adapter'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a22"></a><span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a23"></a><span class="src-doc"> * Doctrine_Adapter_Oracle</span></div></li> <li><div class="src-line"><a name="a24"></a><span class="src-doc"> * [BORROWED FROM ZEND FRAMEWORK]</span></div></li> <li><div class="src-line"><a name="a25"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Doctrine</span></div></li> <li><div class="src-line"><a name="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@subpackage</span><span class="src-doc"> Doctrine_Adapter</span></div></li> <li><div class="src-line"><a name="a28"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Konsta Vesterinen <kvesteri@cc.hut.fi></span></div></li> <li><div class="src-line"><a name="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.opensource.org/licenses/lgpl-license.php LGPL</span></div></li> <li><div class="src-line"><a name="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc"> Object Relational Mapping</span></div></li> <li><div class="src-line"><a name="a31"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@link</span><span class="src-doc"> www.phpdoctrine.com</span></div></li> <li><div class="src-line"><a name="a32"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@since</span><span class="src-doc"> 1.0</span></div></li> <li><div class="src-line"><a name="a33"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 1080 $</span></div></li> <li><div class="src-line"><a name="a34"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a35"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html">Doctrine_Adapter_Oracle</a> <span class="src-key">extends </span><a href="../Doctrine/Doctrine_Adapter.html">Doctrine_Adapter</a></div></li> <li><div class="src-line"><a name="a36"></a><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a37"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a38"></a><span class="src-doc"> * User-provided configuration.</span></div></li> <li><div class="src-line"><a name="a39"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a40"></a><span class="src-doc"> * Basic keys are:</span></div></li> <li><div class="src-line"><a name="a41"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a42"></a><span class="src-doc"> * username => (string) Connect to the database as this username.</span></div></li> <li><div class="src-line"><a name="a43"></a><span class="src-doc"> * password => (string) Password associated with the username.</span></div></li> <li><div class="src-line"><a name="a44"></a><span class="src-doc"> * dbname => Either the name of the local Oracle instance, or the</span></div></li> <li><div class="src-line"><a name="a45"></a><span class="src-doc"> * name of the entry in tnsnames.ora to which you want to connect.</span></div></li> <li><div class="src-line"><a name="a46"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a47"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">array </span></div></li> <li><div class="src-line"><a name="a48"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a49"></a> <span class="src-key">protected </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">$_config</a> = <span class="src-key">array</span><span class="src-sym">(</span></div></li> <li><div class="src-line"><a name="a50"></a> <span class="src-str">'dbname' </span>=> <span class="src-id">null</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a51"></a> <span class="src-str">'username' </span>=> <span class="src-id">null</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a52"></a> <span class="src-str">'password' </span>=> <span class="src-id">null</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a53"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a54"></a> </div></li> <li><div class="src-line"><a name="a55"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a56"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">integer </span></div></li> <li><div class="src-line"><a name="a57"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a58"></a> <span class="src-key">protected </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_execute_mode">$_execute_mode</a> = <span class="src-id">OCI_COMMIT_ON_SUCCESS</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a59"></a> </div></li> <li><div class="src-line"><a name="a60"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a61"></a><span class="src-doc"> * Constructor.</span></div></li> <li><div class="src-line"><a name="a62"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a63"></a><span class="src-doc"> * $config is an array of key/value pairs containing configuration</span></div></li> <li><div class="src-line"><a name="a64"></a><span class="src-doc"> * options. These options are common to most adapters:</span></div></li> <li><div class="src-line"><a name="a65"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a66"></a><span class="src-doc"> * username => (string) Connect to the database as this username.</span></div></li> <li><div class="src-line"><a name="a67"></a><span class="src-doc"> * password => (string) Password associated with the username.</span></div></li> <li><div class="src-line"><a name="a68"></a><span class="src-doc"> * dbname => Either the name of the local Oracle instance, or the</span></div></li> <li><div class="src-line"><a name="a69"></a><span class="src-doc"> * name of the entry in tnsnames.ora to which you want to connect.</span></div></li> <li><div class="src-line"><a name="a70"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a71"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">array </span><span class="src-doc-var">$config </span><span class="src-doc">An array of configuration keys.</span></div></li> <li><div class="src-line"><a name="a72"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@throws</span><span class="src-doc"> Doctrine_Adapter_Exception</span></div></li> <li><div class="src-line"><a name="a73"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a74"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method__construct">__construct</a><span class="src-sym">(</span><span class="src-key">array </span><span class="src-var">$config</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a75"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a76"></a> <span class="src-key">if </span><span class="src-sym">( </span><span class="src-sym">! </span>isset<span class="src-sym">(</span><span class="src-var">$config</span><span class="src-sym">[</span><span class="src-str">'password'</span><span class="src-sym">]</span><span class="src-sym">) </span>|| <span class="src-sym">! </span>isset<span class="src-sym">(</span><span class="src-var">$config</span><span class="src-sym">[</span><span class="src-str">'username'</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a77"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter_Exception.html">Doctrine_Adapter_Exception</a></span><span class="src-sym">(</span><span class="src-str">'config array must have at least a username and a password'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a78"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a79"></a> </div></li> <li><div class="src-line"><a name="a80"></a> <span class="src-comm">// @todo Let this protect backward-compatibility for one release, then remove</span></div></li> <li><div class="src-line"><a name="a81"></a> <span class="src-key">if </span><span class="src-sym">( </span><span class="src-sym">! </span>isset<span class="src-sym">(</span><span class="src-var">$config</span><span class="src-sym">[</span><span class="src-str">'database'</span><span class="src-sym">]</span><span class="src-sym">) </span>|| <span class="src-sym">! </span>isset<span class="src-sym">(</span><span class="src-var">$config</span><span class="src-sym">[</span><span class="src-str">'dbname'</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a82"></a> <span class="src-var">$config</span><span class="src-sym">[</span><span class="src-str">'dbname'</span><span class="src-sym">] </span>= <span class="src-var">$config</span><span class="src-sym">[</span><span class="src-str">'database'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a83"></a> unset<span class="src-sym">(</span><span class="src-var">$config</span><span class="src-sym">[</span><span class="src-str">'database'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a84"></a> <span class="src-id">trigger_error</span><span class="src-sym">(</span><span class="src-str">"Deprecated config key 'database', use 'dbname' instead."</span><span class="src-sym">, </span><span class="src-id">E_USER_NOTICE</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a85"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a86"></a> </div></li> <li><div class="src-line"><a name="a87"></a> <span class="src-comm">// keep the config</span></div></li> <li><div class="src-line"><a name="a88"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a> </span>= <a href="http://www.php.net/array_merge">array_merge</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">, </span>(array) <span class="src-var">$config</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a89"></a> </div></li> <li><div class="src-line"><a name="a90"></a> <span class="src-comm">// create a profiler object</span></div></li> <li><div class="src-line"><a name="a91"></a> <span class="src-var">$enabled </span>= <span class="src-id">false</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a92"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/array_key_exists">array_key_exists</a><span class="src-sym">(</span><span class="src-str">'profiler'</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a93"></a> <span class="src-var">$enabled </span>= (bool) <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">[</span><span class="src-str">'profiler'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a94"></a> unset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">[</span><span class="src-str">'profiler'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a95"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a96"></a> </div></li> <li><div class="src-line"><a name="a97"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_profiler </span>= <span class="src-key">new </span><span class="src-id">Doctrine_Profiler</span><span class="src-sym">(</span><span class="src-var">$enabled</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a98"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a99"></a> </div></li> <li><div class="src-line"><a name="a100"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a101"></a><span class="src-doc"> * Creates a connection resource.</span></div></li> <li><div class="src-line"><a name="a102"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a103"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a104"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@throws</span><span class="src-doc"> Doctrine_Adapter_Oracle_Exception</span></div></li> <li><div class="src-line"><a name="a105"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a106"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_connect">_connect</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a107"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a108"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_resource">is_resource</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a109"></a> <span class="src-comm">// connection already exists</span></div></li> <li><div class="src-line"><a name="a110"></a> <span class="src-key">return</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a111"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a112"></a> </div></li> <li><div class="src-line"><a name="a113"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/extension_loaded">extension_loaded</a><span class="src-sym">(</span><span class="src-str">'oci8'</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a114"></a> throw <span class="src-key">new </span><span class="src-id">Doctrine_Adapter_Oracle_Exception</span><span class="src-sym">(</span><span class="src-str">'The OCI8 extension is required for this adapter but not loaded'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a115"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a116"></a> </div></li> <li><div class="src-line"><a name="a117"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">[</span><span class="src-str">'dbname'</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a118"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection </span>= <span class="src-sym">@</span><span class="src-id">oci_connect</span><span class="src-sym">(</span></div></li> <li><div class="src-line"><a name="a119"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">[</span><span class="src-str">'username'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a120"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">[</span><span class="src-str">'password'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a121"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">[</span><span class="src-str">'dbname'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a122"></a> <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a123"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection </span>= <span class="src-id">oci_connect</span><span class="src-sym">(</span></div></li> <li><div class="src-line"><a name="a124"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">[</span><span class="src-str">'username'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a125"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_config">_config</a></span><span class="src-sym">[</span><span class="src-str">'password'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a126"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a127"></a> </div></li> <li><div class="src-line"><a name="a128"></a> <span class="src-comm">// check the connection</span></div></li> <li><div class="src-line"><a name="a129"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a130"></a> throw <span class="src-key">new </span><span class="src-id">Doctrine_Adapter_Oracle_Exception</span><span class="src-sym">(</span><span class="src-id">oci_error</span><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a131"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a132"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a133"></a> </div></li> <li><div class="src-line"><a name="a134"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a135"></a><span class="src-doc"> * Force the connection to close.</span></div></li> <li><div class="src-line"><a name="a136"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a137"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a138"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a139"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#methodcloseConnection">closeConnection</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a140"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a141"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_resource">is_resource</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a142"></a> <span class="src-id">oci_close</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a143"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a144"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a145"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a146"></a> </div></li> <li><div class="src-line"><a name="a147"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a148"></a><span class="src-doc"> * Returns an SQL statement for preparation.</span></div></li> <li><div class="src-line"><a name="a149"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a150"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$sql </span><span class="src-doc">The SQL statement with placeholders.</span></div></li> <li><div class="src-line"><a name="a151"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">Doctrine_Statement_Oracle </span></div></li> <li><div class="src-line"><a name="a152"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a153"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#methodprepare">prepare</a><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a154"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a155"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_connect">_connect</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a156"></a> <span class="src-var">$stmt </span>= <span class="src-key">new </span><span class="src-id">Doctrine_Statement_Oracle</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">, </span><span class="src-var">$sql</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a157"></a> <span class="src-var">$stmt</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#methodsetFetchMode">setFetchMode</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_fetchMode</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a158"></a> <span class="src-key">return </span><span class="src-var">$stmt</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a159"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a160"></a> </div></li> <li><div class="src-line"><a name="a161"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a162"></a><span class="src-doc"> * Quote a raw string.</span></div></li> <li><div class="src-line"><a name="a163"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a164"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$value </span><span class="src-doc"> Raw string</span></div></li> <li><div class="src-line"><a name="a165"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc"> Quoted string</span></div></li> <li><div class="src-line"><a name="a166"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a167"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_quote">_quote</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a168"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a169"></a> <span class="src-var">$value </span>= <a href="http://www.php.net/str_replace">str_replace</a><span class="src-sym">(</span><span class="src-str">"'"</span><span class="src-sym">, </span><span class="src-str">"''"</span><span class="src-sym">, </span><span class="src-var">$value</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a170"></a> <span class="src-key">return </span><span class="src-str">"'" </span>. <a href="http://www.php.net/addcslashes">addcslashes</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">, </span><span class="src-str">"\000\n\r\\\032"</span><span class="src-sym">) </span>. <span class="src-str">"'"</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a171"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a172"></a> </div></li> <li><div class="src-line"><a name="a173"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a174"></a><span class="src-doc"> * Quote a table identifier and alias.</span></div></li> <li><div class="src-line"><a name="a175"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a176"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string</span><span class="src-doc">|</span><span class="src-doc-type">array</span><span class="src-doc">|</span><span class="src-doc-type">Doctrine_Expr</span><span class="src-doc-var">$ident </span><span class="src-doc">The identifier or expression.</span></div></li> <li><div class="src-line"><a name="a177"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$alias </span><span class="src-doc">An alias for the table.</span></div></li> <li><div class="src-line"><a name="a178"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">The quoted identifier and alias.</span></div></li> <li><div class="src-line"><a name="a179"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a180"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#methodquoteTableAs">quoteTableAs</a><span class="src-sym">(</span><span class="src-var">$ident</span><span class="src-sym">, </span><span class="src-var">$alias</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a181"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a182"></a> <span class="src-comm">// Oracle doesn't allow the 'AS' keyword between the table identifier/expression and alias.</span></div></li> <li><div class="src-line"><a name="a183"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_quoteIdentifierAs</span><span class="src-sym">(</span><span class="src-var">$ident</span><span class="src-sym">, </span><span class="src-var">$alias</span><span class="src-sym">, </span><span class="src-str">' '</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a184"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a185"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a186"></a><span class="src-doc"> * Leave autocommit mode and begin a transaction.</span></div></li> <li><div class="src-line"><a name="a187"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a188"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a189"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a190"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_beginTransaction">_beginTransaction</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a191"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a192"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_setExecuteMode">_setExecuteMode</a><span class="src-sym">(</span><span class="src-id">OCI_DEFAULT</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a193"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a194"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a195"></a><span class="src-doc"> * Commit a transaction and return to autocommit mode.</span></div></li> <li><div class="src-line"><a name="a196"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a197"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a198"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@throws</span><span class="src-doc"> Doctrine_Adapter_Oracle_Exception</span></div></li> <li><div class="src-line"><a name="a199"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a200"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_commit">_commit</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a201"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a202"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-id">oci_commit</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a203"></a> throw <span class="src-key">new </span><span class="src-id">Doctrine_Adapter_Oracle_Exception</span><span class="src-sym">(</span><span class="src-id">oci_error</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a204"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a205"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_setExecuteMode">_setExecuteMode</a><span class="src-sym">(</span><span class="src-id">OCI_COMMIT_ON_SUCCESS</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a206"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a207"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a208"></a><span class="src-doc"> * Roll back a transaction and return to autocommit mode.</span></div></li> <li><div class="src-line"><a name="a209"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a210"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a211"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@throws</span><span class="src-doc"> Doctrine_Adapter_Oracle_Exception</span></div></li> <li><div class="src-line"><a name="a212"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a213"></a> <span class="src-key">protected </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_rollBack">_rollBack</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a214"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a215"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-id">oci_rollback</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a216"></a> throw <span class="src-key">new </span><span class="src-id">Doctrine_Adapter_Oracle_Exception</span><span class="src-sym">(</span><span class="src-id">oci_error</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_connection</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a217"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a218"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_setExecuteMode">_setExecuteMode</a><span class="src-sym">(</span><span class="src-id">OCI_COMMIT_ON_SUCCESS</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a219"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a220"></a> </div></li> <li><div class="src-line"><a name="a221"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a222"></a><span class="src-doc"> * Set the fetch mode.</span></div></li> <li><div class="src-line"><a name="a223"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a224"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@todo</span><span class="src-doc"> Support FETCH_CLASS and FETCH_INTO.</span></div></li> <li><div class="src-line"><a name="a225"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a226"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$mode </span><span class="src-doc">A fetch mode.</span></div></li> <li><div class="src-line"><a name="a227"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a228"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@throws</span><span class="src-doc"> Doctrine_Adapter_Exception</span></div></li> <li><div class="src-line"><a name="a229"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a230"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#methodsetFetchMode">setFetchMode</a><span class="src-sym">(</span><span class="src-var">$mode</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a231"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a232"></a> <span class="src-key">switch </span><span class="src-sym">(</span><span class="src-var">$mode</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a233"></a> <span class="src-key">case </span><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><span class="src-id">FETCH_NUM</span>: <span class="src-comm">// seq array</span></div></li> <li><div class="src-line"><a name="a234"></a> <span class="src-key">case </span><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><span class="src-id">FETCH_ASSOC</span>: <span class="src-comm">// assoc array</span></div></li> <li><div class="src-line"><a name="a235"></a> <span class="src-key">case </span><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><span class="src-id">FETCH_BOTH</span>: <span class="src-comm">// seq+assoc array</span></div></li> <li><div class="src-line"><a name="a236"></a> <span class="src-key">case </span><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><span class="src-id">FETCH_OBJ</span>: <span class="src-comm">// object</span></div></li> <li><div class="src-line"><a name="a237"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id">_fetchMode </span>= <span class="src-var">$mode</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a238"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a239"></a> <span class="src-key">default</span>:</div></li> <li><div class="src-line"><a name="a240"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter_Exception.html">Doctrine_Adapter_Exception</a></span><span class="src-sym">(</span><span class="src-str">'Invalid fetch mode specified'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a241"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a242"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a243"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a244"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a245"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$mode </span></div></li> <li><div class="src-line"><a name="a246"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@throws</span><span class="src-doc"> Doctrine_Adapter_Exception</span></div></li> <li><div class="src-line"><a name="a247"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a248"></a> <span class="src-key">private </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_setExecuteMode">_setExecuteMode</a><span class="src-sym">(</span><span class="src-var">$mode</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a249"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a250"></a> <span class="src-key">switch</span><span class="src-sym">(</span><span class="src-var">$mode</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a251"></a> <span class="src-key">case </span><span class="src-id">OCI_COMMIT_ON_SUCCESS</span>:</div></li> <li><div class="src-line"><a name="a252"></a> <span class="src-key">case </span><span class="src-id">OCI_DEFAULT</span>:</div></li> <li><div class="src-line"><a name="a253"></a> <span class="src-key">case </span><span class="src-id">OCI_DESCRIBE_ONLY</span>:</div></li> <li><div class="src-line"><a name="a254"></a> <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_execute_mode">_execute_mode</a> </span>= <span class="src-var">$mode</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a255"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a256"></a> <span class="src-key">default</span>:</div></li> <li><div class="src-line"><a name="a257"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter_Exception.html">Doctrine_Adapter_Exception</a></span><span class="src-sym">(</span><span class="src-str">'wrong execution mode specified'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a258"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a259"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a260"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a261"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a262"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span></div></li> <li><div class="src-line"><a name="a263"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a264"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#method_getExecuteMode">_getExecuteMode</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a265"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a266"></a> <span class="src-key">return </span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Adapter/Doctrine_Adapter_Oracle.html#var$_execute_mode">_execute_mode</a></span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a267"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a268"></a><span class="src-sym">}</span></div></li> </ol> </span></div> </div>