Thursday Jul 31, 2014
Thursday Oct 24, 2013
By cj on Oct 24, 2013
The PHP OCI8 2.0.6 extension for Oracle Database is now "production" status. The source code is available on PECL. This can be used immediately to update your OCI8 extension in PHP 5.2 and later versions. The extension compiles with Oracle 10.2 or later client libraries. Oracle's standard cross-version database connectivity applies.
OCI8 2.0 and PHP 5.5.5 RPMs for Oracle and Red Hat Linux are available from oss.oracle.com. Windows DLLs are available on PECL for PHP 5.3, PHP 5.4 and PHP 5.5.
OCI8 2.0 source code will also be automatically included in the next major version of PHP.
Oracle Database 12c Implicit Result Set support. IRS's make it easy to pass query results back from stored PL/SQL procedures or anonymous PL/SQL blocks. Individual IRS statement resources, each corresponding to a single query, can be obtained with the new function
oci_get_implicit_resultset(). These 'child' statement resources can be passed to any
oci_fetch_*function. See Using PHP and Oracle Database 12c Implicit Result Sets and the PHP Manual: oci_get_implicit_resultset().
DTrace Dynamic Trace static probes. This well respected DTrace tracing framework is available on a number of platforms, including Oracle Linux. PHP OCI8 static user-space probes can be enabled with PHP's
--enable-dtraceconfiguration option. See Using PHP DTrace on Oracle Linux. Documentation is also available in the PHP Manual OCI8 and DTrace Dynamic Tracing
oci_execute($s, OCI_NO_AUTO_COMMIT)for a
SELECTno longer unnecessarily initiates an internal ROLLBACK during connection close. This can improve overall scalability by reducing "round trips" between PHP and the database.
PHP OCI8 2.0's minimum pre-requisites are now PHP 5.2 and Oracle client library 10.2. Later versions of both are usable and, in fact, recommended. Use the older PHP OCI8 1.4.10 extension when using PHP 4.3.9 through to PHP 5.1.x, or when only Oracle Database 9.2 client libraries are available.
oci_set_*($connection, ...)meta data setting call error handling is fixed so that
oci_error($connection)works for these calls.
Note: The old, deprecated function aliases like
ocilogon still exist but are not recommended for new
Some cosmetic changes were made to the output of
oci8 and the
oci8.connection_classvalues are now shown only when the Oracle client libraries support the respective functionality.
Connection statistics are now in a separate
Temporary LOB and Collection support status lines in
phpinfo()output were removed. These two features have always been enabled since 2007.
oci_internal_debug()function is now a no-op. Use PHP's
--enable-dtracefunctionality with DTrace or SystemTap instead.
Tuesday Apr 30, 2013
By cj on Apr 30, 2013
In case you missed the notifications, the Oracle Technology Network forum software is going to be upgraded this weekend. This is great, since the old software is getting long-in-the-tooth and doesn't allow a bunch of useful features. The current forums will be in read-only mode over the weekend.
On launch of the new version, a minimal set of features will be supported. Once the upgrade is stable, then additional features will be turned on.
As a side part to the migration project, some little used and obsolete forums will be removed. Some other categories will be reworked.
You can get more information about the migration here. One thing to note is that the forum software is powered by Jive; i.e it is a packaged application so not all features you (and I) have requested will magically become feasible. And also, for better or worse, Jive has renamed "forums" as "spaces" - apparently we can't change this.
Monday Oct 24, 2011
By cj on Oct 24, 2011
The Oracle Instant Client 126.96.36.199 for Linux is now available on OTN. I know many users will upgrade sooner rather than later to get the "latest and greatest" release.
However, if your PHP application uses oci_password_change (or its old alias ocipasswordchange), you should upgrade the client libraries (Instant or normal "full" client) and the Oracle Database version to 188.8.131.52 at the same time. Otherwise oci_password_change will fail with the error "ORA-1017: invalid username/password". If you're not using oci_password_change then this won't impact you.
Since the protocol change is in the Oracle libraries, the change is not just limited PHP. Any C program using Oracle's Call Interface "OCIPasswordChange" API to change passwords will also have the same restrictions.
Tuesday Sep 01, 2009
- Running Carsten Czarski's node-oracledb WebSocket Example
- node-oracledb 0.3.1 is on GitHub (Node.js driver for Oracle Database)
- A Personal Victory: Oracle Database Sample Schemas are on GitHub
- Introducing node-oracledb - a Node.js driver for Oracle Database
- The Easiest Way to Enable Oracle Database Application Development on Mac OS X
- How I Enable Autostarting of Oracle Database for Demonstrations and Development
- We are looking to hire someone who loves working with open source developer communities.
- Video: Best Practices for Application Performance, Scalability, and Availability
- Configuring Python cx_Oracle and mod_wsgi on Oracle Linux
- "PL/SQL: The Scripting Language Liberator" - video recording now available