<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Supported Datatypes</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="oci8.dtrace.html">OCI8 and DTrace Dynamic Tracing</a></div>
<div class="next" style="text-align: right; float: right;"><a href="ref.oci8.html">OCI8 Functions</a></div>
<div class="up"><a href="book.oci8.html">OCI8</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="oci8.datatypes" class="chapter">
<h1>Supported Datatypes</h1>
<table class="doctable table">
<caption><strong>The driver supports the following types when binding parameters using
<span class="function"><a href="function.oci-bind-by-name.html" class="function">oci_bind_by_name()</a></span> function:</strong></caption>
<thead>
<tr>
<th>Type</th>
<th>Mapping</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><strong><code>SQLT_NTY</code></strong></td>
<td>Maps a native collection type from a PHP collection object,
such as those created by <span class="function"><a href="function.oci-new-collection.html" class="function">oci_new_collection()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_BFILEE</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_CFILEE</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_CLOB</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_BLOB</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_RDD</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_NUM</code></strong></td>
<td>Converts the PHP parameter to a 'C' long type, and binds to
that value.</td>
</tr>
<tr>
<td><strong><code>SQLT_RSET</code></strong></td>
<td>Maps a native statement handle, such as those created by
<span class="function"><a href="function.oci-parse.html" class="function">oci_parse()</a></span> or those retrieved from other OCI queries.</td>
</tr>
<tr>
<td><strong><code>SQLT_CHR</code></strong> and any other type</td>
<td>Converts the PHP parameter to a string type and binds as a
string.</td>
</tr>
</tbody>
</table>
<table class="doctable table">
<caption><strong>The following types are supported when retrieving columns from a result set:</strong></caption>
<thead>
<tr>
<th>Type</th>
<th>Mapping</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><strong><code>SQLT_RSET</code></strong></td>
<td>Creates an oci statement resource to represent the cursor.</td>
</tr>
<tr>
<td><strong><code>SQLT_RDD</code></strong></td>
<td>Creates a ROWID object.</td>
</tr>
<tr>
<td><strong><code>SQLT_BLOB</code></strong></td>
<td>Creates a LOB object.</td>
</tr>
<tr>
<td><strong><code>SQLT_CLOB</code></strong></td>
<td>Creates a LOB object.</td>
</tr>
<tr>
<td><strong><code>SQLT_BFILE</code></strong></td>
<td>Creates a LOB object.</td>
</tr>
<tr>
<td><strong><code>SQLT_LNG</code></strong></td>
<td>Bound as SQLT_CHR, returned as a string</td>
</tr>
<tr>
<td><strong><code>SQLT_LBI</code></strong></td>
<td>Bound as <strong><code>SQLT_BIN</code></strong>, returned as a string</td>
</tr>
<tr>
<td>Any other type</td>
<td>Bound as <strong><code>SQLT_CHR</code></strong>, returned as a string</td>
</tr>
</tbody>
</table>
</div>
<hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="oci8.dtrace.html">OCI8 and DTrace Dynamic Tracing</a></div>
<div class="next" style="text-align: right; float: right;"><a href="ref.oci8.html">OCI8 Functions</a></div>
<div class="up"><a href="book.oci8.html">OCI8</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
