Posted by John Scoles on Apr 30, 2009
The “Sesame Street” Version of DBD::Oracle (1.23) has been released.
You can find it at CPAN DBD::Oracle.
DBD::Oracle is the Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles, under the auspices of The Pythian Group as open source/free software.
This release is largely a maintenance release that fixes a number of bugs.
New stuff includes the ability to fetch Oracle embedded types directly into an oracle object; a big thank you goes out to Tomas Pokorny for that patch.
Also, UTF8 support has been expanded and cleaned up for BLOBs and execute_array and thanks go out to Milo van der Leij, David Mansfield for most of the work on this.
Also a big thanks Alex Buttery, Jim McCullars, Charles Jardine, Eric Simon, and Chris Underhill, who helped out with some clean up of the code, READMEs, and the POD.
I have also now added two private statement functions ora_stmt_type_name and ora_stmt_type which will get the OCI type name and type for the currently prepared statement.
The complete change list
Read the rest of this entry . . .
Posted by Lukas Vysusil on Apr 14, 2009
E-Business Suite patching is very broad topic. I’m going to cover just a fraction of this vast theme, one that I believe is often overlooked. I decided to split it into two logical parts.
Part 1) Oracle E-Business Suite patch terminology
- patch type hierarchy
- patch naming convention
- naming differences between 11i and R12
Part 2) Querying patches, patchsets, family packs
- how to check if a patch was applied
- what patchset am I on?
- what family pack am I on?
- is there a newer patchset/family pack?
This blog could also be called “Oracle EBS patch evolution theory.” Like any other theory, it can be challenged and proven wrong. I tried to make it unbiased based purely on my experience and to present it in the way that makes sense in context of general patching activities.
Patch hierarchy in 11i
EBS patch taxonomy consists of a number of species. Here is a list of those which I recognize to be valid in the long-term. The exact naming may vary over the years, but the names used here are as they are commonly understood by Apps DBAs.
Read the rest of this entry . . .
Posted by John Scoles on Jan 14, 2008
The latest release of DBD::Oracle is now ready and can be found at: CPAN DBD::Oracle. It is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles as open source/free software, under the auspices of The Pythian Group.
The release has been fully tested with the latest version of DBI (1.601).
Below is the list of the changes and/or fixes in this release. Read the rest of this entry . . .
Posted by John Scoles on Nov 7, 2006
The latest release of DBD::Oracle is now ready and can be found at:
CPAN DBD::Oracle
The release has been fully tested with the latest version of DBI (1.53).
Below is the list of the changes and /or fixes in this release.
- Fixed execute_array to comply with DBI standard from Martin J. Evans, Xho Jingleheimerschmidt and others
- Fixed execute_array so it will not throw a Perl warning on undef values in Tuples from John Scoles
- Fixed execute_array so it will take the ora_array_chunk_size DB handle attribute
- Fixed some typos in code and READMEs from John Scoles
- Fixed a few other little bugs dealing with compatibility with Oracle 8 Changes to README from Karl Auer
- Suppress warning in 26exe_array.t from Philip Garrett
- Added support for array context aware execute_for_fetch from Martin J. Evans
- Fixed Makefile.PL for an incompatibility with ExtUtils::MM_Unix v1.50 (invoked byExtUtils::MakeMaker) from Dennis McRitchie
- Updated POD to reflect that OCI after 9.2 no longer strips trailing spaces
Please enjoy,
John Scoles.
