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
-
[svn:dbd-oracle] r15254 - in dbd-oracle/trunk: . lib/DBD lib/DBD/Oracle
by yanick