Overview
• PHP and the OCI8 Extension
• OCI8 Performance Reminders
• Database Resident Connection Pooling
• Fast Application Notification

What is OCI8?
$c = oci_connect('un', 'pw', '//localhost/XE');
$s = oci_parse($c, 'select * from employees');
oci_execute($s);
while ($row = oci_fetch_array($s))
foreach ($row as $item)
print $item;
?>
• Main Oracle Database extension for PHP
• Open source and part of PHP

OCI8 Basic Oracle Features
• SQL and PL/SQL
• Long Objects (LOB), including Temporary LOBs
• Collections
• REFCURSORS
• Bind Data
• Change Password
• Privileged Connections
• Meta Data

Download