develooper Front page | perl.dbd.oracle.changes | Postings from March 2012

[svn:dbd-oracle] r15254 - in dbd-oracle/trunk: . lib/DBD lib/DBD/Oracle

From:
yanick
Date:
March 30, 2012 11:57
Subject:
[svn:dbd-oracle] r15254 - in dbd-oracle/trunk: . lib/DBD lib/DBD/Oracle
Message ID:
20120330185701.4E39F184B7E@xx12.develooper.com
Author: yanick
Date: Fri Mar 30 11:56:58 2012
New Revision: 15254

Modified:
   dbd-oracle/trunk/Changes
   dbd-oracle/trunk/META.json
   dbd-oracle/trunk/META.yml
   dbd-oracle/trunk/README
   dbd-oracle/trunk/README.mkdn
   dbd-oracle/trunk/lib/DBD/Oracle.pm
   dbd-oracle/trunk/lib/DBD/Oracle/GetInfo.pm
   dbd-oracle/trunk/lib/DBD/Oracle/Object.pm
   dbd-oracle/trunk/lib/DBD/Oracle/Troubleshooting.pm

Log:
v1.43 release

Modified: dbd-oracle/trunk/Changes
==============================================================================
--- dbd-oracle/trunk/Changes	(original)
+++ dbd-oracle/trunk/Changes	Fri Mar 30 11:56:58 2012
@@ -1,6 +1,6 @@
 Revision history for DBD::Oracle
 
-NEXT
+1.43_00   2012-03-30
 
  [BUG FIXES]
  - Applied patch from Rafael Kitover (Caelum) to column_info to handle

Modified: dbd-oracle/trunk/META.json
==============================================================================
--- dbd-oracle/trunk/META.json	(original)
+++ dbd-oracle/trunk/META.json	Fri Mar 30 11:56:58 2012
@@ -6,7 +6,7 @@
       "Yanick Champoux <yanick@cpan.org>"
    ],
    "dynamic_config" : 0,
-   "generated_by" : "Dist::Zilla version 4.300005, CPAN::Meta::Converter version 2.112150",
+   "generated_by" : "Dist::Zilla version 4.300009, CPAN::Meta::Converter version 2.120630",
    "license" : [
       "perl_5"
    ],
@@ -23,62 +23,62 @@
       },
       "runtime" : {
          "requires" : {
-            "DBI" : 0,
-            "DynaLoader" : 0,
-            "Exporter" : 0,
+            "DBI" : "0",
+            "DynaLoader" : "0",
+            "Exporter" : "0",
             "perl" : "5.006",
-            "strict" : 0,
-            "warnings" : 0
+            "strict" : "0",
+            "warnings" : "0"
          }
       },
       "test" : {
          "requires" : {
-            "Carp" : 0,
-            "Config" : 0,
-            "Data::Dumper" : 0,
-            "Devel::Peek" : 0,
-            "Encode" : 0,
-            "Math::BigInt" : 0,
-            "Oraperl" : 0,
-            "Scalar::Util" : 0,
+            "Carp" : "0",
+            "Config" : "0",
+            "Data::Dumper" : "0",
+            "Devel::Peek" : "0",
+            "Encode" : "0",
+            "Math::BigInt" : "0",
+            "Oraperl" : "0",
+            "Scalar::Util" : "0",
             "Test::More" : "0.94",
-            "Thread::Semaphore" : 0,
-            "utf8" : 0,
-            "vars" : 0
+            "Thread::Semaphore" : "0",
+            "utf8" : "0",
+            "vars" : "0"
          }
       }
    },
    "provides" : {
       "DBD::Oracle" : {
          "file" : "lib/DBD/Oracle.pm",
-         "version" : "1.40"
+         "version" : "1.43_00"
       },
       "DBD::Oracle::GetInfo" : {
          "file" : "lib/DBD/Oracle/GetInfo.pm",
-         "version" : "1.40"
+         "version" : "1.43_00"
       },
       "DBD::Oracle::Object" : {
          "file" : "lib/DBD/Oracle/Object.pm",
-         "version" : "1.40"
+         "version" : "1.43_00"
       },
       "DBD::Oracle::Troubleshooting" : {
          "file" : "lib/DBD/Oracle/Troubleshooting.pm",
-         "version" : "1.40"
+         "version" : "1.43_00"
       },
       "DBD::Oracle::db" : {
          "file" : "lib/DBD/Oracle.pm",
-         "version" : "1.40"
+         "version" : "1.43_00"
       },
       "DBD::Oracle::dr" : {
          "file" : "lib/DBD/Oracle.pm",
-         "version" : "1.40"
+         "version" : "1.43_00"
       },
       "DBD::Oracle::st" : {
          "file" : "lib/DBD/Oracle.pm",
-         "version" : "1.40"
+         "version" : "1.43_00"
       }
    },
-   "release_status" : "stable",
+   "release_status" : "testing",
    "resources" : {
       "bugtracker" : {
          "mailto" : "bug-dbd-oracle at rt.cpan.org",
@@ -91,11 +91,7 @@
          "web" : "http://github.com/yanick/DBD-Oracle/tree"
       }
    },
-<<<<<<< HEAD
-   "version" : "1.38",
-=======
-   "version" : "1.40",
->>>>>>> build/master
+   "version" : "1.43_00",
    "x_authority" : "cpan:PYTHIAN"
 }
 

Modified: dbd-oracle/trunk/META.yml
==============================================================================
--- dbd-oracle/trunk/META.yml	(original)
+++ dbd-oracle/trunk/META.yml	Fri Mar 30 11:56:58 2012
@@ -20,7 +20,7 @@
 configure_requires:
   ExtUtils::MakeMaker: 6.30
 dynamic_config: 0
-generated_by: 'Dist::Zilla version 4.300005, CPAN::Meta::Converter version 2.112150'
+generated_by: 'Dist::Zilla version 4.300009, CPAN::Meta::Converter version 2.120630'
 license: perl
 meta-spec:
   url: http://module-build.sourceforge.net/META-spec-v1.4.html
@@ -29,25 +29,25 @@
 provides:
   DBD::Oracle:
     file: lib/DBD/Oracle.pm
-    version: 1.40
+    version: 1.43_00
   DBD::Oracle::GetInfo:
     file: lib/DBD/Oracle/GetInfo.pm
-    version: 1.40
+    version: 1.43_00
   DBD::Oracle::Object:
     file: lib/DBD/Oracle/Object.pm
-    version: 1.40
+    version: 1.43_00
   DBD::Oracle::Troubleshooting:
     file: lib/DBD/Oracle/Troubleshooting.pm
-    version: 1.40
+    version: 1.43_00
   DBD::Oracle::db:
     file: lib/DBD/Oracle.pm
-    version: 1.40
+    version: 1.43_00
   DBD::Oracle::dr:
     file: lib/DBD/Oracle.pm
-    version: 1.40
+    version: 1.43_00
   DBD::Oracle::st:
     file: lib/DBD/Oracle.pm
-    version: 1.40
+    version: 1.43_00
 requires:
   DBI: 0
   DynaLoader: 0
@@ -59,5 +59,5 @@
   bugtracker: http://rt.cpan.org/Public/Dist/Display.html?Name=DBD-Oracle
   homepage: http://search.cpan.org/dist/DBD-Oracle/
   repository: git://github.com/yanick/DBD-Oracle.git
-version: 1.40
+version: 1.43_00
 x_authority: cpan:PYTHIAN

Modified: dbd-oracle/trunk/README
==============================================================================
--- dbd-oracle/trunk/README	(original)
+++ dbd-oracle/trunk/README	Fri Mar 30 11:56:58 2012
@@ -2,7 +2,7 @@
     DBD::Oracle - Oracle database driver for the DBI module
 
 VERSION
-    version 1.40
+    version 1.43_00
 
 SYNOPSIS
       use DBI;
@@ -1030,15 +1030,16 @@
         See "Row Prefetching" for more details.
 
    Placeholders
-    There are two types of placeholders that can be used in DBD::Oracle. The
-    first is the "question mark" type, in which each placeholder is
+    There are three types of placeholders that can be used in DBD::Oracle.
+
+    The first is the "question mark" type, in which each placeholder is
     represented by a single question mark character. This is the method
-    recommended by the DBI specs and is the most portable. Each question
-    mark is internally replaced by a "dollar sign number" in the order in
-    which they appear in the query (important when using "bind_param").
+    recommended by the DBI and is the most portable. Each question mark is
+    internally replaced by a "dollar sign number" in the order in which they
+    appear in the query (important when using "bind_param").
 
-    The other placeholder type is "named parameters" in the format ":foo"
-    which is the one Oralce prefers.
+    The second type of placeholder is "named parameters" in the format
+    ":foo" which is the one Oracle prefers.
 
        $dbh->{RaiseError} = 1;        # save having to check each method call
        $sth = $dbh->prepare("SELECT name, age FROM people WHERE name LIKE :name");
@@ -1046,6 +1047,17 @@
        $sth->execute;
        DBI::dump_results($sth);
 
+    Note when calling bind_param with named parameters you must include the
+    leading colon. The advantage of this placeholder type is that you can
+    use the same placeholder more than once in the same SQL statement but
+    you only need to bind it once.
+
+    The last placeholder type is a variation of the two above where you name
+    each placeholder :N (where N is a number). Like the named placeholders
+    above you can use the same placeholder multiple times in the SQL but
+    when you call bind_param you only need to pass the N (e.g., for :1 you
+    use bind_param(1,...) and not bind_param(':1',...).
+
     The different types of placeholders cannot be mixed within a statement,
     but you may use different ones for each statement handle you have. This
     is confusing at best, so stick to one style within your program.

Modified: dbd-oracle/trunk/README.mkdn
==============================================================================
--- dbd-oracle/trunk/README.mkdn	(original)
+++ dbd-oracle/trunk/README.mkdn	Fri Mar 30 11:56:58 2012
@@ -4,7 +4,7 @@
 
 # VERSION
 
-version 1.40
+version 1.43_00
 
 # SYNOPSIS
 
@@ -1109,13 +1109,17 @@
 
 ### __Placeholders__
 
-There are two types of placeholders that can be used in DBD::Oracle. The first is
-the "question mark" type, in which each placeholder is represented by a single
-question mark character. This is the method recommended by the DBI specs and is the most
-portable. Each question mark is internally replaced by a "dollar sign number" in the order
-in which they appear in the query (important when using [bind_param](#pod_bind_param)).
+There are three types of placeholders that can be used in
+DBD::Oracle.
 
-The other placeholder type is "named parameters" in the format ":foo" which is the one Oralce prefers.
+The first is the "question mark" type, in which each placeholder is
+represented by a single question mark character. This is the method
+recommended by the DBI and is the most portable. Each question
+mark is internally replaced by a "dollar sign number" in the order in
+which they appear in the query (important when using [bind_param](#pod_bind_param)).
+
+The second type of placeholder is "named parameters" in the format
+":foo" which is the one Oracle prefers.
 
    $dbh->{RaiseError} = 1;        # save having to check each method call
    $sth = $dbh->prepare("SELECT name, age FROM people WHERE name LIKE :name");
@@ -1123,6 +1127,17 @@
    $sth->execute;
    DBI::dump_results($sth);
 
+Note when calling bind_param with named parameters you must include
+the leading colon. The advantage of this placeholder type is that you
+can use the same placeholder more than once in the same SQL statement
+but you only need to bind it once.
+
+The last placeholder type is a variation of the two above where you
+name each placeholder :N (where N is a number). Like the named
+placeholders above you can use the same placeholder multiple times in
+the SQL but when you call bind_param you only need to pass the N
+(e.g., for :1 you use bind_param(1,...) and not bind_param(':1',...).
+
 The different types of placeholders cannot be mixed within a statement, but you may
 use different ones for each statement handle you have. This is confusing at best, so
 stick to one style within your program.
@@ -4234,4 +4249,4 @@
 This software is copyright (c) 1994 by Tim Bunce.
 
 This is free software; you can redistribute it and/or modify it under
-the same terms as the Perl 5 programming language system itself.
+the same terms as the Perl 5 programming language system itself.
\ No newline at end of file

Modified: dbd-oracle/trunk/lib/DBD/Oracle.pm
==============================================================================
--- dbd-oracle/trunk/lib/DBD/Oracle.pm	(original)
+++ dbd-oracle/trunk/lib/DBD/Oracle.pm	Fri Mar 30 11:56:58 2012
@@ -12,7 +12,7 @@
 {
 package DBD::Oracle;
 {
-  $DBD::Oracle::VERSION = '1.40';
+  $DBD::Oracle::VERSION = '1.43_00';
 }
 BEGIN {
   $DBD::Oracle::AUTHORITY = 'cpan:PYTHIAN';
@@ -125,7 +125,7 @@
 
 {   package DBD::Oracle::dr;
 {
-  $DBD::Oracle::dr::VERSION = '1.40';
+  $DBD::Oracle::dr::VERSION = '1.43_00';
 }
 BEGIN {
   $DBD::Oracle::dr::AUTHORITY = 'cpan:PYTHIAN';
@@ -330,7 +330,7 @@
 
 {   package DBD::Oracle::db;
 {
-  $DBD::Oracle::db::VERSION = '1.40';
+  $DBD::Oracle::db::VERSION = '1.43_00';
 }
 BEGIN {
   $DBD::Oracle::db::AUTHORITY = 'cpan:PYTHIAN';
@@ -1059,7 +1059,7 @@
 
 {   package DBD::Oracle::st;
 {
-  $DBD::Oracle::st::VERSION = '1.40';
+  $DBD::Oracle::st::VERSION = '1.43_00';
 }
 BEGIN {
   $DBD::Oracle::st::AUTHORITY = 'cpan:PYTHIAN';
@@ -1164,7 +1164,7 @@
 
 =head1 VERSION
 
-version 1.40
+version 1.43_00
 
 =head1 SYNOPSIS
 

Modified: dbd-oracle/trunk/lib/DBD/Oracle/GetInfo.pm
==============================================================================
--- dbd-oracle/trunk/lib/DBD/Oracle/GetInfo.pm	(original)
+++ dbd-oracle/trunk/lib/DBD/Oracle/GetInfo.pm	Fri Mar 30 11:56:58 2012
@@ -1,6 +1,6 @@
 package DBD::Oracle::GetInfo;
 {
-  $DBD::Oracle::GetInfo::VERSION = '1.40';
+  $DBD::Oracle::GetInfo::VERSION = '1.43_00';
 }
 BEGIN {
   $DBD::Oracle::GetInfo::AUTHORITY = 'cpan:PYTHIAN';
@@ -295,7 +295,7 @@
 
 =head1 VERSION
 
-version 1.40
+version 1.43_00
 
 =head1 AUTHORS
 

Modified: dbd-oracle/trunk/lib/DBD/Oracle/Object.pm
==============================================================================
--- dbd-oracle/trunk/lib/DBD/Oracle/Object.pm	(original)
+++ dbd-oracle/trunk/lib/DBD/Oracle/Object.pm	Fri Mar 30 11:56:58 2012
@@ -1,6 +1,6 @@
 package DBD::Oracle::Object;
 {
-  $DBD::Oracle::Object::VERSION = '1.40';
+  $DBD::Oracle::Object::VERSION = '1.43_00';
 }
 BEGIN {
   $DBD::Oracle::Object::AUTHORITY = 'cpan:PYTHIAN';
@@ -39,7 +39,7 @@
 
 =head1 VERSION
 
-version 1.40
+version 1.43_00
 
 =head1 AUTHORS
 

Modified: dbd-oracle/trunk/lib/DBD/Oracle/Troubleshooting.pm
==============================================================================
--- dbd-oracle/trunk/lib/DBD/Oracle/Troubleshooting.pm	(original)
+++ dbd-oracle/trunk/lib/DBD/Oracle/Troubleshooting.pm	Fri Mar 30 11:56:58 2012
@@ -1,6 +1,6 @@
 package DBD::Oracle::Troubleshooting;
 {
-  $DBD::Oracle::Troubleshooting::VERSION = '1.40';
+  $DBD::Oracle::Troubleshooting::VERSION = '1.43_00';
 }
 BEGIN {
   $DBD::Oracle::Troubleshooting::AUTHORITY = 'cpan:PYTHIAN';
@@ -17,7 +17,7 @@
 
 =head1 VERSION
 
-version 1.40
+version 1.43_00
 
 =head1 CONNECTING TO ORACLE
 



nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About