Module Name:	pkgsrc
Committed By:	grant
Date:		Sun Mar  4 01:04:11 UTC 2007

Modified Files:
	pkgsrc/databases/p5-DBD-Oracle: Makefile distinfo

Log Message:
update DBD::Oracle to 1.19.

Changes in DBD-Oracle 1.19 (svn rev 8002) 3rd November 2006

  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 a few other little bugs dealing with  compatibility with Oracle 8
  Added support for array context aware execute_for_fetch from Martin J. Evans

Changes in DBD-Oracle 1.18 (svn rev 6697)

  Added support for native Oracle Array interface thanks Kristian Nielsen
  Added suppot for LOB Locators from Jeffrey Klein.

Changes in DBD-Oracle 1.17 (svn rev 3726)

  Added expanded support for Lobs from Jeffrey Klein
  Fixed automatic csform setting for some UTF8 cases and for Oracle 8.0
  Fixed truncation error on fetch into UTF8 charset thanks to Honza Pazdziora.
  Fixed INTERVAL DAY TO SECOND thanks to Honza Pazdziora.
  Fixed unicode tests for cygwin thanks to Andy Hassall.
  Fixed undef warnings when connecting with undef $user.
  Fixed undef warnings from $dbh->get_info(18);
  Fixed LOB streaming example thanks to Pablo Zorzoli.

  Added support for nested cursors in select lists thanks to Charles Jardine.
  Added "Trailing Spaces" section to docs thanks to Michael A Chase.
  Added support for binary floats/doubles thanks to Dennis Box.
  Added INSTANCE_NAME, SERVER and SERVICE_NAME as valid connect keywords
    in the 'dbi:Oracle:x=y' short form of connecting without tnsnames.ora.
    For example 'dbi:Oracle:host=localhost;service_name=xe;server=dedicated'
  Added auto-detection of ORACLE_HOME in some configurations.

Changes in DBD-Oracle 1.16 (svn rev 515)   22nd October 2004

  NOTE:
  This release has major changes to Unicode support. See below.
  It no longer supports the old Oracle 7 OCI interface.
  It requires DBI >= 1.38 for some of the tests if using Perl 5.6.
  It no longer supports Perl 5.5 or earlier.

  Fixed placeholder names to be case insensitive thanks to Charles Jardine.
  Fixed some LOB test problems with Oracle 8.1.7 by implementing ora_lob_append
    with OCILobGetLength() and OCILobWrite(), instead of buggy OCILobWriteAppend(),
    if the Oracle client version is < 9.0. Thanks to Jeff Urlwin.
  Fixed handling of temporary LOBs thanks to Chris Donnelly.
  Fixed memory leaks in auto LOB refetch code thanks to Dongqiang Bai.
  Fixed reporting of length truncated in error message thanks to Jeff Urlwin.
  Fixed column_info() to handle TIMESTAMP and INTERVAL datatypes
    for Oracle >= 8 thanks to Stephen Clouse.
  Fixed STORE to cache attribute value in handle cache.
  Fixed seg fault returning LOB Locators reported by Raj Chandran.
  Fixed binding to allow overloaded scalars (not for 'inout' params).
  Fixed setting of $DBI::err to 0 triggering PrintWarn in DBI >= 1.41.
  Fixed some edge cases in row cache sizing.
  Fixed truncation error fetching very small numbers (1 ^ -130).
  Fixed Oraperl to not enable PrintError or AutoCommit (broken since 1.13).

  Changed some utf8 internals for LOBs.
  Changed ORA_OCI constant from being just 7 or 8 to being a dualvar:
    in numeric context returns the major.minor version number (8.1, 9.2 etc)
    in string context it returns the full "major.minor.foo.bar" version string.
  Changed some SUCCESS_WITH_INFO situtions to be treated as a "warning"
    by setting $DBI::err to "0" (and so trigger PrintWarn in DBI >= 1.43)
    eg "ORA-28011: the account will expire soon; change your password now"
    and package compilation errors.

  Added automatic support for UTF-8 for both NLS_LANG and NLS_NCHAR
    Many thanks to Lincoln Baxter who did most of the hard work and testing
    and to Jeff Urlwin and others who also helped out.
    Perl 5.8.x and Oracle 9+ are highly recommended if you want to use Unicode.
    See POD for more information and documentation.
  Added support for "... RETURNING lob_locator_column INTO ?"
    using $sth->bind_param_inout(2, \$loc, 0, {ora_type => ORA_BLOB});
  Added bind_param() ora_csform, ora_csid, and ora_maxdata_size attributes.
  Added bind_param() support for SQL_BLOB & SQL_CLOB thanks to Stephen Clouse.
  Added $dbh->ora_can_unicode and $dbh->ora_nls_parameters thanks to Andy Hassall.

Changes in DBD-Oracle 1.15   27th January 2004

  NOTE: DBD::Oracle now requires DBI version 1.28 (June 2002) or later.

  NOTE: This is probably the last release that will support being
  built with the old Oracle 7 OCI interface.

  Fixed for extproc_perl (http://search.cpan.org/author/JHORWITZ/extproc_perl/)
  Fixed Oraperl handling of ora_errno and ora_errstr thanks to Martin Busik.
  Fixed PRECISION for "NUMBER" to be 126 not 0 thanks to Steffen Goeldner.
  Fixed bind_param_inout() for placeholders not assigned to in PL/SQL.

  Changed bind_param_inout for CHAR types to no longer use a minimum
    length of 28 characters. Warning: this change may break code that
    doesn't pass bind_param_inout() a length value large enough for the
    returned string. (The minimum length was not documented and should
    not have been relied upon. This change currently only applies to the
    CHAR type but may extended to all string types in a later release.)
  Changed type_info_all() to return the same type info as Oracle's own
    ODBC driver does, thanks to Andy Hassall for the data.
    The types include LOBs but not the new TIMESTAMP and INTERVAL types.

  Added direct access to LOB Locators and major LOB Locator functions
    such as $sth->ora_lob_read(...), $sth->ora_lob_write(...) etc.
    This work was sponsored by Geospiza Inc.
  Added LOB Locator example docs thanks to Mark Dilger at Geospiza.
  Added TIMESTAMP [WITH [LOCAL] TIME ZONE]] support
    thanks to Stephen Clouse and Robert Wyrick.
  Added INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND support.
  Added /*+RULE*/ hint to metadata method SQL thanks to Andy Hassall.
  Added connect example using OS authentication thanks to Bob Thomson.
  Added prepare("...", { ora_placeholders => 0 }) to disable placeholders.
  Added docs for returning a recordset (table/array) using Oracle >=9.0.1
    via "FUNCTION foo RETURN type PIPELINED" thanks to Steve Baldwin.
  Added docs on ora_check_sql=>0 in prepare() to avoid server-side parses.
  Added support for sharing database connections with ProC/SQLLIB code
    via ora_use_proc_connection attribute, thanks to Kristian Nielsen
    needs build time option thanks to Steffen Goeldner
  Added (restored) the error "possibly near <*> indicator" marker for
    syntax errors thanks to Jason Hitt and Andy Hassall.
  Added $dbh->{ora_parse_error_offset} attribute thanks to Andy Hassall.
  Added auto setting of $dbh->{Username} if not given to connect
    i.e. using Oracle OS authentication and connecting as "/"
    by selecting SYS_CONTEXT('userenv','session_user') from the db
    thanks to Eric Lenio and Andy Hassall.


To generate a diff of this commit:
cvs rdiff -r1.8 -r1.9 pkgsrc/databases/p5-DBD-Oracle/Makefile
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/p5-DBD-Oracle/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.