PHP and Oracle: Christopher Jones

Converting REF CURSOR to PIPE for Performance in PHP OCI8 and PDO_OCI

By christopher.jones on November 3, 2008 5:24 PM

REF CURSORs are common in Oracle's stored procedural language PL/SQL. They let you pass around a pointer to a set of query results. However in PHP, PDO_OCI doesn't yet allow fetching from them. And fetching from REF CURSORS in OCI8...

Comments (2)

Oracle 11g Result Caching and PHP OCI8

By christopher.jones on October 28, 2008 12:00 AM

Oracle Database 11g introduced "server-side"and "client-side" result caches. The database cache is enabled with the RESULT_CACHE_MODE database parameter, which has several modes. With the default mode, queries for which you want results to be cached need a hint added: $s...

Comments (4)

Speeding up DBMS_OUTPUT in PHP OCI8

By christopher.jones on October 24, 2008 2:13 PM

Immediately after OOW, Alison and I have got straight into updating the Underground PHP & Oracle Manual. We've had our heads right down. Stay tuned. We've still got a few items on our ToDo list but the new, improved version...

Comments (2)