PHP Oracle FAQ - History Page

	Date/Time	Made By	Edit Note	Type	Scope
	Oct 9 2009, 11:56 AM EDT	christopher.jones	Mention Oracle 11.2 REF CURSOR prefetching	edit	79 words added
Change: If you have linked PHP with Oracle 11.2 client libraries, pre-fetching also works when fetching from REF CURSORS. The default prefetch size will automatically be used, or it can be set per-statement:<?php $conn = oci_connect('myusername', 'mypassword', 'mydb');$stid = oci_parse($conn, "call myproc(:rc)"); // PL/SQL procedure is: myproc(rc_p OUT SYS_REFCURSOR) View changes from previous version. (Word count: 6860)
	Jul 29 2009, 5:42 PM EDT	pleleu		edit	1 word added 1 word deleted
Change: document.documentation. User annotations give tips and tricks.The OCI8 test suite in the PHP Source code shows the expected behavior of OCI8 calls in detail.What are the ORA, OCI8 and PDO_OCI extensionsOCI8 extension: Oracle Call Interface functions OCI8 is the recommended PHP View changes from previous version. (Word count: 6769)
	Jul 27 2009, 7:25 PM EDT	christopher.jones	Change UG P&O Manual links to new landing page	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 6769)
	Jun 4 2009, 1:29 PM EDT	christopher.jones	More PDO_OCI additions	edit	181 words added 118 words deleted
Change: The connection string "myhost/XE" may also be replaced by a TNS net service name as described in the previous question.Why do I get the error "Call to undefined function: oci_connect() / ocilogon()"?Check phpinfo() output and make sure there is a View changes from previous version. (Word count: 6769)
	Jun 4 2009, 1:01 PM EDT	christopher.jones	Add note about not needing ORACLE_HOME for Instant Client	edit	28 words added 1 word deleted
Change: To ensure the correct character set is used, you may also want to set NLS_LANG. Apache, PHP and Oracle error messages that use phrases like "could not load" or "could not resolve" View changes from previous version. (Word count: 6698)
	Jun 3 2009, 1:02 PM EDT	christopher.jones	Some reordering	edit	903 words added 858 words deleted
Change: Note that when oci_commit() or oci_rollback() are used, or oci_execute() autocommits, all transactions on other statement handles for the connection are committed or rolled back. View changes from previous version. (Word count: 6671)
	Jun 3 2009, 12:46 PM EDT	christopher.jones	Add OTN Forum link. Add PDO_OCI connection example.	edit	140 words added 8 words deleted
Change: The connection string "myhost/XE" may also be replaced by a TNS net service name as described in the previous question.Why do I get the error "Call to undefined function: oci_connect() / ocilogon()"?Check phpinfo() output and make sure there is a section titled OCI8. The pre-built View changes from previous version. (Word count: 6623)
	Apr 10 2009, 2:27 PM EDT	christopher.jones	Merge connection questions	edit	589 words added 584 words deleted
Change: Please note that PHP will share/re-use connections if the same userid/password combination is used (more than once) on a particular "page" or httpd server session. View changes from previous version. (Word count: 6494)
	Apr 10 2009, 2:21 PM EDT	christopher.jones	whitespace	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 6488)
	Apr 7 2009, 8:29 PM EDT	christopher.jones		edit	52 words added 40 words deleted
Change: Test all return values from OCI8 functions to prevent hidden problems and misleading results and use oci_error() to fetch the error message.How can I insert strings containing quotes? Inserting strings containing single quotes can be handled in several ways: 1. Use bind variables. This View changes from previous version. (Word count: 6488)
	Apr 7 2009, 2:05 PM EDT	christopher.jones		edit	17 words added
Change: software updates available from Zend.After an extensive private and public Beta cycle, Zend Server was declared production on April 7, 2009Zend Server includes the OCI8 1.3 extension (which support Oracle 11g Database Resident Connection Pooling) and bundles the Oracle 11g Instant Client libraries. View changes from previous version. (Word count: 6474)
	Apr 6 2009, 11:56 PM EDT	christopher.jones		edit	32 words added 3 words deleted
Change: as application monitoring, problem diagnostics,diagnostics and application performance optimization,optimization. It has full support and software updates.updates available from Zend.Zend Server includes the OCI8 1.3 extension (which support Oracle 11g Database Resident Connection Pooling) and bundles the Oracle 11g Instant Client libraries. View changes from previous version. (Word count: 6457)
	Apr 6 2009, 11:41 PM EDT	christopher.jones		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 6427)
	Apr 6 2009, 11:38 PM EDT	christopher.jones	Add Zend info	edit	172 words added
Change: Server is a complete, enterprise-ready Web Application Server for running and managing PHP applications that require a high level of reliability, performance and security. It includes out-of-box connectivity for Oracle databases on Windows and Linux, as well as application monitoring, problem diagnostics, application performance optimization, full support and software updates. View changes from previous version. (Word count: 6427)
	Apr 6 2009, 11:23 PM EDT	christopher.jones	Formatting	edit	3 words added
Change: 1. If Oracle 10g or 11g libraries are used by PHP, try the new Easy Connect syntax. No long connection string is needed. No tnsnames.ora file is required. To connect to the MYDB database service running on mymachine use: $c = oci_connect('myusername', 'mypassword', 'mymachine.mydomain/MYDB'); If you are View changes from previous version. (Word count: 6248)
	Apr 6 2009, 11:17 PM EDT	christopher.jones		edit	2 words added 6 words deleted
Change: , which hosts this FAQ, has many good resources.The technical note on Installing PHP and the Oracle Instant Client for Linux and Windows is also on OTN.A free book on how to use PHP and Oracle from Oracle discusses many details about OCI8 best practices.Various books View changes from previous version. (Word count: 6245)
	Apr 6 2009, 11:14 PM EDT	christopher.jones	More content	edit	533 words added 2 words deleted
Change: The OCI8 extension function names were standardized in PHP 5. Most changes were the addition of underscores, for example OCIBindByName() is now oci_bind_by_name(). A couple View changes from previous version. (Word count: 6248)
	Apr 6 2009, 10:37 PM EDT	christopher.jones	More content	edit	1073 words added
Change: If oci_bind_by_name() is called inside a wrapper function or method and the PHP variable passed to oci_bind_by_name() is local to the wrapper function there may View changes from previous version. (Word count: 5702)
	Apr 6 2009, 10:31 PM EDT	christopher.jones	More content	edit	2454 words added
Change: The Oracle directory that PHP links with needs to be readable by the owner of the web server process. If you configure PHP to use View changes from previous version. (Word count: 4619)
	Apr 6 2009, 10:20 PM EDT	christopher.jones	Add content	edit	1665 words added 5 words deleted
Change: The connection string can be an "Easy Connect" string or an Oracle Net alias from the tnsnames.ora file. The Easy Connect syntax requires no configuration View changes from previous version. (Word count: 2020)