Author: byterock Date: Tue Feb 19 11:51:16 2008 New Revision: 10805 Modified: dbd-oracle/trunk/Changes dbd-oracle/trunk/Oracle.pm dbd-oracle/trunk/README.win32.txt
Log: changes to pod for NULL LOBS Modified: dbd-oracle/trunk/Changes ============================================================================== --- dbd-oracle/trunk/Changes (original) +++ dbd-oracle/trunk/Changes Tue Feb 19 11:51:16 2008 @@ -1,3 +1,10 @@ +=head1 Changes in DBD-Oracle 1.21(svn rev xxxx) + + Added suppot for bind_param_inout_array with use with execute_array from John Scoles + Added enhancement for Embedded Objects handling from Paul G. Weiss + Fixed to Makefile.PL let it read makefiles from other makes from Alexander V Alekseev + Updated POD to account for rt.cpan.org #30910: "DBD-Oracle crashes when trying to read empty LOB" By John Scoles + =head1 Changes in DBD-Oracle 1.20(svn rev 10517) 11th January 2008 Fixed lob test so it skips the one test that relies on it if v$ session. from Rafael Kitover Modified: dbd-oracle/trunk/Oracle.pm ============================================================================== --- dbd-oracle/trunk/Oracle.pm (original) +++ dbd-oracle/trunk/Oracle.pm Tue Feb 19 11:51:16 2008 @@ -2452,7 +2452,20 @@ The value of an Oracle LOB column is not the content of the LOB. It's a 'LOB Locator' which, after being selected or inserted needs extra -processing to read or write the content of the LOB. +processing to read or write the content of the LOB. This being said if your +LOB column is a NULL LOB then the locator is null and there is no locator for +DBD::Oracle to work with and it will return a + + DBD::Oracle::db::ora_lob_read: locator is not of type OCILobLocatorPtr + +error. + +To correct for this you must use an SQL UPDATE statement to reset the +LOB column to a non-NULL (or empty) value with an SQL like this; + + UPDATE lob_example + SET bindata=EMPTY_BLOB() + WHERE bindata IS NULL. When fetching LOBs they are, by default, made to look just like LONGs and are subject to the LongReadLen and LongTruncOk attributes. Note that Modified: dbd-oracle/trunk/README.win32.txt ============================================================================== --- dbd-oracle/trunk/README.win32.txt (original) +++ dbd-oracle/trunk/README.win32.txt Tue Feb 19 11:51:16 2008 @@ -12,7 +12,7 @@ The preferred method of getting DBD::Oracle is to use a pre-built version from the ActiveState repository, which can be installed with PPM. -Compiling and installing DBD::Oracle 1.18 on a windows 2000 professional or XP OS for use +Compiling and installing DBD::Oracle 1.18 or later on a windows 2000 professional or XP OS for use with Oracle instantClient ver 10.2.0.1 & 10.1.0.5 or Oracle XE requires only a few downloads and a minimal number of environment setting. The procedures below were tested on a clean Windows platform having no Oracle or other development environment installed.
