Package: libdbd-oracle-perl
Version: 1.34-1.1~asd3
Severity: normal
Tags: patch

As of 11gR2 (maybe earlier) there is another session mode (along with
SYSDBA and SYSOPER) of SYSASM. The attached patch adds it to
DBD::Oracle.

-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (500, 'testing'), (200, 'unstable'), (150, 'stable'), (100, 
'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 3.1.0-1-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages libdbd-oracle-perl depends on:
ii  libaio1                       0.3.109-2 
ii  libc6                         2.13-21   
ii  libdbi-perl [perl-dbdabi-94]  1.616-1+b2
ii  perl                          5.14.2-5  
ii  perl-base [perlapi-5.14.2]    5.14.2-5  

libdbd-oracle-perl recommends no packages.

Versions of packages libdbd-oracle-perl suggests:
ii  perl-tk  1:804.029-1.1+b2

-- no debconf information
>From 58d6f2821008ad0307e4969f7a9b0717dd63f165 Mon Sep 17 00:00:00 2001
From: Anthony DeRobertis <aderober...@metrics.net>
Date: Tue, 6 Dec 2011 12:50:05 -0500
Subject: [PATCH] add SYSASM

---
 Oracle.pm        |   10 +++++-----
 Oracle.xs        |    1 +
 debian/changelog |    6 ++++++
 3 files changed, 12 insertions(+), 5 deletions(-)

diff --git a/Oracle.pm b/Oracle.pm
index e509e00..19cd1c7 100644
--- a/Oracle.pm
+++ b/Oracle.pm
@@ -27,7 +27,7 @@ my $ORACLE_ENV  = ($^O eq 'VMS') ? 'ORA_ROOT' : 'ORACLE_HOME';
 	    ORA_CLOB ORA_BLOB ORA_RSET ORA_VARCHAR2_TABLE ORA_NUMBER_TABLE
 	    SQLT_INT SQLT_FLT ORA_OCI SQLT_CHR SQLT_BIN
 	) ],
-        ora_session_modes => [ qw( ORA_SYSDBA ORA_SYSOPER ) ],
+        ora_session_modes => [ qw( ORA_SYSDBA ORA_SYSOPER ORA_SYSASM ) ],
         ora_fetch_orient  => [ qw( OCI_FETCH_NEXT OCI_FETCH_CURRENT OCI_FETCH_FIRST
         			   OCI_FETCH_LAST OCI_FETCH_PRIOR OCI_FETCH_ABSOLUTE
         			   OCI_FETCH_RELATIVE)],
@@ -1183,7 +1183,7 @@ So to make a short story a little longer;
 
 =item :ora_session_modes
 
-ORA_SYSDBA ORA_SYSOPER
+ORA_SYSDBA ORA_SYSOPER ORA_SYSASM
 
 =item :ora_types
 
@@ -1817,9 +1817,9 @@ successive failover events when the event is OCI_FO_ERROR.
 
 =head4 ora_session_mode
 
-The ora_session_mode attribute can be used to connect with SYSDBA
-authorization and SYSOPER authorization.
-The ORA_SYSDBA and ORA_SYSOPER constants can be imported using
+The ora_session_mode attribute can be used to connect with SYSDBA,
+SYSOPER, or SYSDBA authorization.
+The ORA_SYSDBA, ORA_SYSOPER, and ORA_SYSDBA constants can be imported using
 
   use DBD::Oracle qw(:ora_session_modes);
 
diff --git a/Oracle.xs b/Oracle.xs
index 8466751..dede0ae 100644
--- a/Oracle.xs
+++ b/Oracle.xs
@@ -29,6 +29,7 @@ constant(name=Nullch)
 	ORA_NUMBER_TABLE	= ORA_NUMBER_TABLE
 	ORA_SYSDBA	 		= 0x0002
 	ORA_SYSOPER	 		= 0x0004
+	ORA_SYSASM          = 0x8000
 	SQLCS_IMPLICIT 		= SQLCS_IMPLICIT
 	SQLCS_NCHAR			= SQLCS_NCHAR
 	SQLT_INT	 		= SQLT_INT
diff --git a/debian/changelog b/debian/changelog
index 7835619..d7eeedc 100644
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,3 +1,9 @@
+libdbd-oracle-perl (1.34-1.1~asd3) unstable; urgency=low
+
+  * Add SYSASM session mode.
+
+ -- Anthony DeRobertis <anth...@derobert.net>  Tue, 06 Dec 2011 12:49:18 -0500
+
 libdbd-oracle-perl (1.34-1.1~asd2) unstable; urgency=low
 
   * Rebuild with Oracle 11gR2
-- 
1.7.7.3

Reply via email to