DBD::Oracle - rt13865.t

2012-12-13 Thread Scott
'} ) ){ #and ( $priv{'DROP TABLE'} or $priv{'DROP ANY TABLE'} ) ) { plan skip_all = q{requires permissions 'CREATE TABLE' and 'DROP TABLE'}; } Scott

Re: DBD::Oracle - rt13865.t

2012-12-13 Thread Scott
Do you have the DROP ANY TABLE privilege set for the userid? That is the only DROP TABLE priv I can see, so I probably need to have the dba grant it to my install-test user. On 12/13/2012 11:03 AM, Martin J. Evans wrote: On 13/12/12 16:38, Scott wrote: I have to comment out the 'DROP

Re: ANNOUNCE: DBD::Oracle 1.25 Release Candidate 1

2010-07-16 Thread Scott T. Hildreth
value from Martin J Evans and a bunch of re jigging from John Scoles Patch for PL/SQL: numeric or value error: character string buffer too small from Scott T. Hildreth Fix for rt.cpan.org Ticket #=51594 type_info and type_info_all miss vital information from John Scoles Added

Re: DBD::Oracle 11gr2 ORA-38909

2010-05-21 Thread Scott T. Hildreth
until it is tested hopefully by you Scott Cheers John Scoles -- See Pythian's Alex Gorbachev, co-author of Expert Oracle Practices at NoCOUG Spring Conference May 20th. Details, interview book chapter in the May NoCOUG Journal: http://bit.ly/alexnocoug I'm not sure why I

Re: DBD::Oracle 11gr2 ORA-38909

2010-04-06 Thread Scott T. Hildreth
On Tue, 2010-04-06 at 09:51 +0100, Martin Evans wrote: I haven't seen a reply to this yet but I've been on holiday so might have missed it: Scott T. Hildreth wrote: On Wed, 2010-03-31 at 12:20 -0500, Scott T. Hildreth wrote: We have run into an issue with array processing in 11g

Re: DBD::Oracle 11gr2 ORA-38909

2010-04-02 Thread Scott T. Hildreth
On Wed, 2010-03-31 at 12:20 -0500, Scott T. Hildreth wrote: We have run into an issue with array processing in 11g. The developer was using execute_array and his sql statement had 'LOG ERRORS' in it. This did not error out until we switched to 11g. The issue is that only one is allowed

DBD::Oracle 11gr2 ORA-38909

2010-03-31 Thread Scott T. Hildreth
it to OCI_BATCH_MODE and running a test to see if this will not error out. I report back when I have run the test, but I was wondering what would be the best way to give the user the ability to override the oci_mode. An attribute in the prepare method? Thanks, Scott

Comments on this patch for dbms_output_get() ?

2010-03-31 Thread Scott T. Hildreth
or return undef; Thanks, Scott

Re: DBD::Oracle 1.20 - t/80ora_charset.t fails 4 tests

2008-03-12 Thread Scott T. Hildreth
that is set or a patch or lack thereof on Oracle that might cause it. I will keep this patch for now in reserve if other people start complaining about this test cheers John Scoles On Wed, 2008-03-05 at 17:39 -0600, Scott T. Hildreth wrote: On Thu, 2008-02-14 at 10:03 -0600, Scott T

DBD::Oracle - execute_array core dumps intermittently

2008-03-05 Thread Scott T. Hildreth
I am not sure how to describe this, my co-worker will run his process and get a core dump (I pasted the back trace below) and then run the process again with no core dumps. Sometimes it will core dump several times in a row and then the next run it finishes fine. I ran the process with

Re: DBD::Oracle 1.20 - t/80ora_charset.t fails 4 tests

2008-03-05 Thread Scott T. Hildreth
On Thu, 2008-02-14 at 10:03 -0600, Scott T. Hildreth wrote: not ok 9 - match char # Failed test 'match char' # at t/80ora_charset.t line 83. # got: '?' # expected: ' ' /\ || a char I can't print, looks like a degree

Re: DBD::Oracle 1.20 - t/80ora_charset.t fails 4 tests

2008-03-05 Thread Scott T. Hildreth
On Wed, 2008-03-05 at 17:39 -0600, Scott T. Hildreth wrote: On Thu, 2008-02-14 at 10:03 -0600, Scott T. Hildreth wrote: not ok 9 - match char # Failed test 'match char' # at t/80ora_charset.t line 83. # got: '?' # expected

DBD::Oracle 1.20 - t/80ora_charset.t fails 4 tests

2008-02-14 Thread Scott T. Hildreth
not ok 9 - match char # Failed test 'match char' # at t/80ora_charset.t line 83. # got: '?' # expected: ' ' /\ || a char I can't print, looks like a degree symbol :-) not ok 10 - match char # Failed test 'match char' # at

Re: DBD::Proxy - getting unitialized error for $numFields

2007-04-26 Thread Scott T. Hildreth
On Wed, 2007-04-25 at 22:34 +0100, Tim Bunce wrote: On Wed, Apr 25, 2007 at 02:45:47PM -0500, Scott T. Hildreth wrote: On Wed, 2007-03-28 at 21:26 +0100, Tim Bunce wrote: On Wed, Mar 28, 2007 at 01:54:51PM -0500, Scott T. Hildreth wrote: I should also mention that this is a $dbh-do

Re: DBI-1.54 proxy connect errors

2007-04-24 Thread Scott T. Hildreth
On Mon, 2007-04-23 at 16:41 -0500, Scott T. Hildreth wrote: On Mon, 2007-04-23 at 21:23 +0100, Tim Bunce wrote: On Mon, Apr 23, 2007 at 12:38:36PM -0500, Scott T. Hildreth wrote: On Mon, 2007-04-23 at 12:34 -0500, Scott T. Hildreth wrote: I can confirm this, http

Re: DBI-1.54 proxy connect errors

2007-04-23 Thread Scott T. Hildreth
On Mon, 2007-04-23 at 12:34 -0500, Scott T. Hildreth wrote: I can confirm this, http://groups.google.com/group/linux.debian.bugs.dist/browse_thread/thread/aa1a09e3ac0aa54f/6d96262964f376aa?lnk=stq=Not+permitted+for+method+connected+of+class+DBI%3A%3AProxyServer%3A%3Adb+rnum=1#6d96262964f376aa

DBI-1.54 proxy connect errors

2007-04-23 Thread Scott T. Hildreth
. At first I thought it was a problem with 64bit Perl client connecting to 32bit Perl Server, but downgrading to DBI-1.53 on the 64bit server fixes the Proxy problem. I will try DBI-1.55rc1 and report back. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBD::mysql 4.004 Released!

2007-04-11 Thread Scott T. Hildreth
. On Wed, 2007-03-28 at 13:01 -0500, Scott T. Hildreth wrote: Feel free to send it to me before release, we will have the old client on that server until we upgrade it. Which will be awhile. On Tue, 2007-03-27 at 22:18 -0400, Patrick Galbraith wrote: Scott, Thanks! I need to somehow

Re: DBD::mysql 4.004 Released!

2007-04-11 Thread Scott T. Hildreth
On Wed, 2007-04-11 at 09:59 -0500, Scott T. Hildreth wrote: I had to add this to dbdimp.c, mysql_warning_count() is not implemented before 4.1, #if MYSQL_VERSION_ID = SQL_STATE_VERSION imp_sth-warning_count = mysql_warning_count(imp_dbh-mysql); #else imp_sth-warning_count = 0; #endif

Re: DBD::Proxy - getting unitialized error for $numFields

2007-03-29 Thread Scott T. Hildreth
On Wed, 2007-03-28 at 21:26 +0100, Tim Bunce wrote: On Wed, Mar 28, 2007 at 01:54:51PM -0500, Scott T. Hildreth wrote: I should also mention that this is a $dbh-do( an insert statement). A quick look at DBI::ProxyServer, shows that the NUMFIELDS indicates a select, therefore in this case

Re: DBD::Proxy - getting unitialized error for $numFields

2007-03-28 Thread Scott T. Hildreth
is to run the Proxy server in debug mode and figure out why numFields is not filled in. I was hoping someone might know what is going on before I do that. Thanks On Thu, 2007-01-18 at 15:37 -0600, Scott T. Hildreth wrote: ### Perl

Re: DBD::Proxy - getting unitialized error for $numFields

2007-03-28 Thread Scott T. Hildreth
On Wed, 2007-03-28 at 15:59 -0500, Scott T. Hildreth wrote: On Wed, 2007-03-28 at 21:26 +0100, Tim Bunce wrote: On Wed, Mar 28, 2007 at 01:54:51PM -0500, Scott T. Hildreth wrote: I should also mention that this is a $dbh-do( an insert statement). A quick look at DBI::ProxyServer, shows

DBD::Gofer::Execute - daemon

2007-03-28 Thread Scott T. Hildreth
process enable transactions for DBD::Gofer? Probably still stateless, thought I would ask. If so please start a new thread and I'll give a brain dump... -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBD::mysql 4.004 Released!

2007-03-28 Thread Scott T. Hildreth
Feel free to send it to me before release, we will have the old client on that server until we upgrade it. Which will be awhile. On Tue, 2007-03-27 at 22:18 -0400, Patrick Galbraith wrote: Scott, Thanks! I need to somehow find a 4.0 binary for OS X to find these pesky things. regards

Re: DBD::mysql 4.004 Released!

2007-03-26 Thread Scott T. Hildreth
can delete a file on CPAN, you cannot re-upload it if it's the same name. Mea Culpa. * UTF8-Flag not set with flag mysql_enable_utf8 and column collation utf8_bin patch, Joost Diepenmaat, (RT #24738) * Fixed do_error definition (Scott Hildreth, Tim Bunce) * Conversion of test suite

Re: DBD::mysql 4.003 Released! - Error Compiling

2007-03-12 Thread Scott T. Hildreth
of the failures are due to the older client being used. Would you like a patch of what I changed? Thanks. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBD::mysql 4.003 Released! - Error Compiling

2007-03-08 Thread Scott T. Hildreth
On Wed, 2007-03-07 at 16:58 -0600, Scott T. Hildreth wrote: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ... So my client is not = to SQL_STATE_VERSION, but dbdimp.c still has do_error accepting a sqlstate param, void do_error(SV* h, int rc, const char* what, const char

Re: DBD::mysql 4.003 Released! - Error Compiling

2007-03-08 Thread Scott T. Hildreth
On Thu, 2007-03-08 at 12:23 -0600, Scott T. Hildreth wrote: On Wed, 2007-03-07 at 16:58 -0600, Scott T. Hildreth wrote: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ... So my client is not = to SQL_STATE_VERSION, but dbdimp.c still has do_error accepting a sqlstate param

Re: DBD::mysql 4.003 Released! - Error Compiling

2007-03-07 Thread Scott T. Hildreth
size: 121582 bytes md5: 157f817d26a52aaaff61ce38f7043b95 -- Scott T. Hildreth [EMAIL PROTECTED]

Re: ANNOUNCE: DBI 1.54 RC2 - including cool new DBD::Gofer stateless proxy

2007-02-02 Thread Scott T. Hildreth
) and removes dependency on Class::Accessor. I'd be grateful for any testing, and especially for feedback on DBD::Gofer (previously mentioned as DBD::Forward, but DBD::Gofer is a much better name :) Enjoy! Tim. -- Scott T. Hildreth [EMAIL PROTECTED]

Re: ANNOUNCE: DBI 1.54 RC2 - including cool new DBD::Gofer stateless proxy

2007-02-02 Thread Scott T. Hildreth
On Fri, 2007-02-02 at 11:50 +, Tim Bunce wrote: FreeBSD 6.1 This is perl, v5.8.8 built for i386-freebsd ** All tests pass. -- Scott T. Hildreth [EMAIL PROTECTED]

Fwd: [Pdl-porters] PDL - RDBMS linkage

2006-11-22 Thread Jonathan Scott Duff
-- Forwarded message -- From: Jonathan Scott Duff [EMAIL PROTECTED] Date: Nov 22, 2006 2:45 PM Subject: Re: [Pdl-porters] PDL - RDBMS linkage To: [EMAIL PROTECTED] Cc: pdl-porters@jach.hawaii.edu, [EMAIL PROTECTED] On 11/22/06, Doug Hunt [EMAIL PROTECTED] wrote: Hi Jonathan

Re: Testing DBD::Oracle array interface

2006-06-07 Thread Scott T. Hildreth
the implementation been made more efficient? Thanks, Shree -- Scott T. Hildreth [EMAIL PROTECTED]

Re: DBI - where has dbish and DBD::Shell.pm gone

2006-05-10 Thread Scott T. Hildreth
up. dbish is not up to the greatness of DBI I suggest documenting in DBI that there is no more dbish -- Scott T. Hildreth [EMAIL PROTECTED]

Re: %ENV changes not seen by other libraries in same process on cygwin

2006-01-17 Thread Yitzchak Scott-Thoennes
On Mon, Jan 16, 2006 at 11:58:48PM -, Andy Hassall wrote: So, what's the options? Here's some: I haven't looked at the code that's failing, so some of my comments may be misguided. (3) Get DBD::Oracle to call the win32 SetEnvironmentVariable directly, at least during the testsuite, if

Re: Problem loading data in a DB2 database via perl-DBI

2005-10-31 Thread Dan Scott
Can you please post the Perl code you're using (or at least the section relevant to the prepare_cached() method and failure) so we can give you a little more help? Thanks, Dan On 10/31/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I am using a perl script to load data in a DB2 database

Re: DBD::Oracle 10.1 client

2005-10-21 Thread Scott T. Hildreth
this is a known bug. I copied the table to a 9i instance and the ran the code below, and it worked fine. So it seems to be related to 10g. Thu, 2005-10-20 at 14:07 -0500, Scott T. Hildreth wrote: I am going to investigate more, but I thought I would post the question to see if anyone has run

Re: connected() doesn't get all attributes

2005-06-22 Thread Peter Scott
On Tue, 21 Jun 2005 21:42:42 +0100, Tim Bunce wrote: On Tue, Jun 21, 2005 at 06:46:03AM -0700, Peter Scott wrote: - $dbh-connected($dsn, $user, $pass, $attr) if ref $dbh ne 'DBI::db'; +# We'll normalize the dsn first + $dbh-connected(dbi:$driver($driver_attrib_spec):$dsn

Re: connected() doesn't get all attributes

2005-06-21 Thread Peter Scott
On Tue, 21 Jun 2005 01:13:21 +0100, Tim Bunce wrote: On Sun, Jun 19, 2005 at 06:16:25AM -0700, Peter Scott wrote: On Sat, 18 Jun 2005 15:34:36 +0100, Tim Bunce wrote: On Fri, Jun 17, 2005 at 05:49:01PM -0700, Peter Scott wrote: The connected() method of subclasses doesn't get all

Re: connected() doesn't get all attributes

2005-06-19 Thread Peter Scott
On Sat, 18 Jun 2005 15:34:36 +0100, Tim Bunce wrote: On Fri, Jun 17, 2005 at 05:49:01PM -0700, Peter Scott wrote: The connected() method of subclasses doesn't get all the attribute that were set by the caller; three of them are deleted first: [snip] I'd rather like to get those attributes

connected() doesn't get all attributes

2005-06-17 Thread Peter Scott
off so you can't tell which driver was used. That information would be most valuable to my application. It does seem from reading the documentation as though the expectation is that connected() will get the same arguments as connect(), so would a patch for this be accepted also? -- Peter Scott

Re: [dbi] Re: Savepoint support proposal

2005-03-09 Thread Dan Scott
On Wed, 9 Mar 2005 13:29:40 -0800, Darren Duncan [EMAIL PROTECTED] wrote: At 8:55 AM + 3/9/05, Martin J. Evans wrote: Just a small point. I could be wrong (I cannot look it up right now) but I think in ODBC SQLEndTran can issue a rollback or commit on ALL connections. Effectively, it

Re: Named bind params with DBD::Proxy

2004-10-22 Thread Scott T. Hildreth
Tim, Are you still maintaining DBD::Proxy? Have you had a request for supporting named parameters? STH On Thu, 2004-10-21 at 16:55, Scott T. Hildreth wrote: I was going bring this up myself. I had this problem the other day. To get it working I changed

Re: ORA-12154

2004-08-03 Thread Scott T. Hildreth
This should be on the dbi-users list. Are you sure all of the environment variables are set? Can you show the code? The ORA-12154 is TNS error, 12154, 0, TNS:could not resolve service name // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. //

Re: ANNOUNCE: DBI 1.42 release candidate 4 for testing

2004-03-12 Thread Scott T. Hildreth
All test pass, FreeBSD 4.9 perl 5.8.1 On Fri, 2004-03-12 at 07:21, Tim Bunce wrote: On Fri, Mar 12, 2004 at 12:01:55AM +, Tim Bunce wrote: On Thu, Mar 11, 2004 at 04:26:40PM +, Tim Bunce wrote: A release candidate is available for testing at: And another: And another:

RE: ANNOUNCE: DBI 1.42 release candidate 4 for testing

2004-03-12 Thread Scott T. Hildreth
http://lists.perl.org/showlist.cgi?name=dbi-dev On Fri, 2004-03-12 at 11:05, Lance Prais wrote: How do I get removed from this list? I am so tired of seeing 30- messages in my inbox from Tim Bruce.. Please help -Original Message- From: Scott T. Hildreth [mailto:[EMAIL

Re: ANNOUNCE: DBI 1.42 release candidate 2 for testing

2004-03-11 Thread Scott T. Hildreth
David, I have had similar problems with FreeBSD, Linux, and OSF. http://www.perlmonks.org/index.pl?node_id=323847 what ended up doing is renaming the site_perl/5.6.1 directory to a temp name, while I upgraded to 5.8.*. Once everything was installed under 5.8.*, moved

Re: Quoted Identiers - problem in DBD::ODBC 0.32

2002-02-05 Thread Scott T. Hildreth
() is currently a fairly slowly moving target and has a way to go yet before it's ready for drivers to use. ..and the code that is in current DBI has changed quite a bit. -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 05-Feb-02 Time: 08:36:46 --

Re: SQL Implementation Specifics

2002-01-25 Thread Scott T. Hildreth
. STH -- E-Mail: Scott T. Hildreth [EMAIL PROTECTED] Date: 25-Jan-02 Time: 12:59:39 --