Re: There's an error, but $sth-execute returns -1

2010-10-19 Thread Martin J. Evans
On 18/10/10 23:05, Tim Bunce wrote: On Sat, Oct 16, 2010 at 11:03:08AM +0100, Martin J. Evans wrote: On 15/10/2010 22:20, Roode, Eric wrote: Hello all, DBI docs says that statement handle method execute() returns undef on error. I have found a situation where that does not hold

Re: There's an error, but $sth-execute returns -1

2010-10-19 Thread Martin J. Evans
On 18/10/10 22:54, Tim Bunce wrote: On Mon, Oct 18, 2010 at 04:45:51PM +0100, Martin J. Evans wrote: State 23000 you are getting is Integrity constraint violation which is an error but note the text on the end of the error you are getting: [state was 23000 now 01000] 01000 is a general

Re: There's an error, but $sth-execute returns -1

2010-10-19 Thread Martin J. Evans
On 19/10/2010 18:03, Roode, Eric wrote: On Tuesday, October 19, 2010 3:59 AM, Martin J. Evans wrote: All drivers I've tried this with report 2 things. The 23000 error for the insert of a null into a column which does not allow nulls (the tds_error packet) then a 01000 informational (tds_info

Re: DBD::Oracle-1.26 fails test t/31lob.t on Oracle 11gR2 Ubuntu 10.04

2010-10-19 Thread Martin J. Evans
On 19/10/2010 18:17, CAMPBELL, ED (ATTBST) wrote: I'm not sure exactly how to run the prove command. When I try it as prove t/31lob.t it gives: Can't locate DBD/Oracle.pm in @INC (@INC contains: /etc/perl /usr/local/lib/per. BEGIN failed--compilation aborted at t/31lob.t line 5. # Looks like

Re: test dbi__null_test_tmp with MS Access Driver

2010-10-22 Thread Martin J. Evans
On 20/10/10 21:36, Memo Garcia wrote: Hi, Only for completeness of the manual, I include the results of perl_dbi_nulls_test.pl using MS Access Thanks, Added, thanks. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

New experimental DBD::ODBC 1.26_1 release

2010-10-26 Thread Martin J. Evans
declarations Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle on zLinux/s390x?

2010-10-27 Thread Martin J. Evans
happened. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: ANNOUNCE DBD Oracle 1.27 Release Candidate 1

2010-11-05 Thread Martin J. Evans
) Using DBI 1.615 One compiler warning: oci8.c:3898: warning: cast from function call of type ‘size_t’ to non-matching type ‘void *’ the usual 2 test failures: t/26exe_array.t (Wstat: 512 Tests: 17 Failed: 2) Failed tests: 11, 14 Martin -- Martin J. Evans Easysoft Limited http

DBD::ODBC 1.26_2 bug fix development release

2010-11-09 Thread Martin J. Evans
(namebuf), %d, (int)SvIV(ph_namesv)); name_len = strlen(name); } else { Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

new development release of DBD::ODBC - 1.26_3

2010-11-18 Thread Martin J. Evans
It turns out an optimization I made in 1.24_2 causes problems and ultimately leads to rebinding columns unnecessarily and leaking memory. 1.26_3 fixes this problem (thanks to Steve Bentley for spotting this). If you are using a development release of DBD::ODBC you are strongly recommended to

Re: Potential problem with DBD::Oracle

2010-11-18 Thread Martin J. Evans
On 18/11/2010 20:15, Steve Baldwin wrote: Hi, I ran across an issue recently that appears to have existed for quite some time. Consider the following script ... #!/usr/bin/perl -w use strict; use warnings; use DBI; sub main { my $dbh = DBI-connect( 'dbi:Oracle:',

Re: DBD::Oracle dbd_st_execute slow speed

2010-12-09 Thread Martin J. Evans
to run forever in a loop. Please consider the environment before printing this email. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle dbd_st_execute slow speed

2010-12-09 Thread Martin J. Evans
and the other it was Oracle deciding not to use the index because of data type mismatches. Is there perhaps a difference in how you are connecting between DBD::Oracle and sqlplus? Was sqlplus command and Perl script run from same machine? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

New bug fix DBD::ODBC 1.26_4 release

2010-12-14 Thread Martin J. Evans
Removed some silly code from dbd_db_execdirect which attempted to return -3 - don't think it could ever get run. Minor tracing output tidy up Removed dbd_caution as it was no used Localised more variable declarations Martin -- Martin J. Evans Easysoft Limited http

Re: ODBC/SQL Server select bug

2010-12-19 Thread Martin J. Evans
On 19/12/2010 23:15, Darin Burleigh wrote: Weird error SELECTing from SQL Server 2005 via ODBC, which shows under the following conditions: * select contains 'left outer join' to a secondary table * select contains an 'order by' clause * the DBI-connect statement contains the option:

Re: DBD::Oracle, 10g Lob Refetch problem

2010-12-21 Thread Martin J. Evans
On 21/12/10 09:18, Michael Ludwig wrote: Martin J. Evans schrieb am 21.12.2010 um 09:03 (+): e.g. for my database here with a SID of devel where the database is running on betoracle.easysoft.local and my user is fred/password I do: export ORACLE_USERID=fred/password Minor correction

New official DBD::ODBC 1.27 release

2010-12-29 Thread Martin J. Evans
DBD::ODBC 1.27 is winging its way to CPAN now. Version 1.27 combines all the 1.26 development releases and is a significant release as DBD::ODBC is now entirely ODBC 3.0 and requires an ODBC Driver Manager for any ODBC 2.0 drivers. Many thanks to everyone who has contributed. The changes are

Re: Potential problem with DBD::Oracle

2011-01-13 Thread Martin J. Evans
On 18/11/10 20:24, Martin J. Evans wrote: On 18/11/2010 20:15, Steve Baldwin wrote: Hi, I ran across an issue recently that appears to have existed for quite some time. Consider the following script ... #!/usr/bin/perl -w use strict; use warnings; use DBI; sub main { my $dbh

Re: Potential problem with DBD::Oracle

2011-01-13 Thread Martin J. Evans
On 13/01/11 17:21, Martin J. Evans wrote: On 18/11/10 20:24, Martin J. Evans wrote: On 18/11/2010 20:15, Steve Baldwin wrote: Hi, I ran across an issue recently that appears to have existed for quite some time. Consider the following script ... #!/usr/bin/perl -w use strict; use

Re: DBI test fail

2011-01-21 Thread Martin J. Evans
- should not be too lon. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Downside to ora_envhp=0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-26 Thread Martin J. Evans
perhaps trap the error to allocate a connection when the environment is dead and reallocate the environment. May be John Scoles has a comment on this and if so it could be rt'ed. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: AIX DBD::Oracle perl Makefile.PL core dumps

2011-01-28 Thread Martin J. Evans
On 28/01/2011 20:22, Williams, Stephen wrote: Afternoon all, I am having trouble with trying to compile the DBD drive for Oracle on my AIX 5.3 TL11 host. I have DBI-1.616 installed on the node fine, but when I go to run the perl Makefile.PL I keep getting a core dump. The perl installation is

Re: DBD::Oracle 'make test' fails - ORA-24327: need explicit attach before authenticating a user

2011-02-02 Thread Martin J. Evans
=//myoraclemachine.domain.com/sid always works for me and you don't need to set up tnsnames. I don't think you need ORACLE_HOME set with instant client, just LD_LIBRARY_PATH. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Need HELP: trying to install DBI-1.613 or even DBI-1.616 same errors ...see message??

2011-02-12 Thread Martin J. Evans
On 12/02/2011 01:45, Arifuddin, Arif wrote: HELP: $ uname -a SunOS recondfw 5.10 Generic_139556-08 i86pc i386 i86pc isainfo -v 64-bit amd64 applications ssse3 cx16 mon sse3 sse2 sse fxsr mmx cmov amd_sysc cx8 tsc fpu 32-bit i386 applications ssse3 cx16 mon sse3 sse2 sse fxsr

Re: DBI error

2011-02-22 Thread Martin J. Evans
at shchgsum.pl line 22. BEGIN failed--compilation aborted at shchgsum.pl line 22. Did you rebuild DBI and DBD::Oracle after upgrading? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

DBD::ODBC 1.28_3 development release

2011-02-22 Thread Martin J. Evans
some of the examples Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Numeric and string columns.

2011-02-26 Thread Martin J. Evans
On 26/02/2011 01:50, Bill Moseley wrote: Columns coming from DBD::Pg seems to all be Perl strings and then when I encode to json then end up quoted: music=# \d cd; Table public.cd Column | Type |Modifiers

DBD::ODBC 1.28_5 development release

2011-03-06 Thread Martin J. Evans
I'm not proving to be too good at guessing when the 1.29 official release will be made. As so often happens whenever I announce a possible release a whole host of new issues come along. Mostly, the changes since 1.28_5 are workarounds for Firebird and freeTDS ODBC drivers but there are other

New 1.29 release of DBD::ODBC

2011-03-08 Thread Martin J. Evans
Clarified versions for MARS_Connection updates to cancel_big_fetch.pl Updated TO_DO with more stuff to do Improved tracing output Tidied up some of the examples Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Proposed change to disconnect in DBD::ODBC

2011-03-16 Thread Martin J. Evans
something like: DBD::ODBC::db disconnect warning: Disconnect with transaction in progress - rolling back Obviously if you have PrintWarn turned off or are not using warnings it won't make any difference to you. Anyone have any fundamental objections to this change. Martin -- Martin J. Evans

Re: Proposed change to disconnect in DBD::ODBC

2011-03-16 Thread Martin J. Evans
definitely a mistake if your code could use multiple DBDs). Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Error 'making DBD:Oracle 1.28 on Cygwin W

2011-03-25 Thread Martin J. Evans
On 25/03/11 09:28, Alexander Foken wrote: (Sorry for the empty reply, wrong button clicked ...) Adding the line to oci.def helped, DBD::Oracle 1.28 compiles fine with the patch on W2K / Strawberry 5.12 / Oracle 10.2g. The test t/26exe_array.t failes due to a bad plan, 406 test planned, but 407

Re: DBD::Oracle 1.27 and bind_col()

2011-03-25 Thread Martin J. Evans
- bind_col($n=1,\$dummy) runs # Failed test 'bind_col($n=1,\$dummy) runs' # at /home/martin/bind_col_str.pl line 55. # Looks like you failed 2 tests of 4. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle 1.27 and bind_col()

2011-03-25 Thread Martin J. Evans
On 25/03/11 11:06, Martin J. Evans wrote: On 24/03/11 15:26, Alexander Foken wrote: Hello List, could someone with a working DBD::Oracle 1.28 please verify that the tests 2 and 4 in the attached test script fail? All test pass with DBD::Oracle 1.23, tests 2 and 4 fail with DBD::Oracle 1.27

Re: Oracle 11R2, perl-DBD: eating signal CTRL-C

2011-05-03 Thread Martin J. Evans
of this this - the client libs must be using the signal for something. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: (Fwd) Perl DBI on Mac OS X

2011-05-03 Thread Martin J. Evans
config file points the SQL Server entry to the path/name of the shared object is wrong or you don't have all the dependencies to load it (on Linux I'd run ldd on the shared object pointed to but I don't know the equivalent on MAC). Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: (Fwd) Perl DBI on Mac OS X

2011-05-05 Thread Martin J. Evans
'. So do you want to connect to MS SQL Server or MySQL? You need different ODBC drivers for each. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

New 1.30_1 development release of DBD::ODBC

2011-05-12 Thread Martin J. Evans
I've just uploaded DBD::ODBC 1.30_1 to CPAN. If you use Windows or a Unicode build of DBD::ODBC on non-Windows platforms you should really test this release as it contains a change in behaviour for Unicode. This release also contains a small but perhaps significant change to the silent

Re: DBD::ODBC Segfaults on SET TEXTSIZE and TRUNCATE TABLE

2011-05-17 Thread Martin J. Evans
. Martin -Original Message- From: Berg, Eric: IT (NYK) Sent: Friday, May 13, 2011 9:24 AM To: 'Martin J. Evans' Cc: dbi-users@perl.org Subject: RE: DBD::ODBC Segfaults on SET TEXTSIZE and TRUNCATE TABLE Thanks, Martin. I've been working with Richard on this for a few days and he's been very

Re: (Fwd) Re: DBD::Oracle Slow cursors

2011-05-17 Thread Martin J. Evans
On 17/05/2011 22:18, Tim Bunce wrote: - Forwarded message from P S Jameel Ahamedjaha...@idexcel.com - Date: Tue, 17 May 2011 16:11:04 +0100 From: P S Jameel Ahamedjaha...@idexcel.com To: tim.bu...@pobox.com Subject: Re: DBD::Oracle Slow cursors X-Mailer: Microsoft Office Outlook 11

Re: What's the relationship between LongReadLen and TEXTSIZE?

2011-05-18 Thread Martin J. Evans
standalone example which creates a table and demonstrates the issue I will look at it. Eric Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

DBD::ODBC 1.30_4 development release

2011-05-18 Thread Martin J. Evans
on bound parameter problems. * Added new FAQ entry for Firebird * Removed some unused variables and added some missing function prototypes Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: What's the relationship between LongReadLen and TEXTSIZE?

2011-05-19 Thread Martin J. Evans
) whereas DBD::Sybase is for Sybase/MS SQL Server which both support TEXTSIZE. If TEXTSIZE is 80 then you'll always have to set LongReadLen to get all the data without truncating it. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com -Original Message- From: Martin J

Re: Update is not working properly with Perl DBI

2011-05-19 Thread Martin J. Evans
were processed, you just commit all the updates. }else { sleep(5); } } Did you intend to sleep for 10s when there are no ids or 5? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: (Fwd) Question about DBD::Oracle

2011-05-24 Thread Martin J. Evans
and allow embedded \0 bytes. Oracle clients using OCI 9.2 do not strip trailing spaces and allow embedded \0 bytes. This is the normal default placeholder type. Yours faithfully, Kiyoshi Sumiya, - End forwarded message - -- Martin J. Evans

Re: Assigning private attributes to DBI database handles

2011-06-03 Thread Martin J. Evans
On 03/06/2011 19:30, eric.b...@barclayscapital.com wrote: I'd like to set some private attributes on my db handles so that later I can interrogate them to get that information. We are doing this with statement handles, but not DB handles, and it simply doesn't seem to be working in any case.

Re: DBD::ODBC Segfaults on SET TEXTSIZE and TRUNCATE TABLE

2011-06-03 Thread Martin J. Evans
, martin.ev...@easysoft.com (Martin J. Evans) wrote: On 17/05/2011 14:54, eric.b...@barclayscapital.com wrote: Just a quick update: We switched back to using the FreeTDS driver under DBD::ODBC with the unixODBC ODBC manager on Linux and the segfault problem went away. That seems to suggest to me

Re: DBD::Sybase and DBI-get_info()

2011-06-04 Thread Martin J. Evans
On 03/06/2011 20:58, eric.b...@barclayscapital.com wrote: Thanks, John. If anyone can comment with authority on the lack of intraspection capabilities in DBD::Sybase, that'd be helpful. I looked through the code as well, and didn't find anything to say one way or another. Get_info() appears

Re: Handling DATE Field in DBD:::Teradata.pm

2011-06-10 Thread Martin J. Evans
me on this? Thanks Pariksheet I don't use Teradata so I could be way off here. Perhaps that is the default format for dates in your database. Perhaps you can cast it with a format - select cast(date as date format '-MM-DD') - something like that. Martin -- Martin J. Evans Easysoft Limited

Re: can $dbh-do take a prepared statement handle?

2011-06-17 Thread Martin J. Evans
the $s statement handle was stringified into something like DBI::st=HASH(0x8e7e2c0) Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

DBD::ODBC 1.31 released

2011-06-23 Thread Martin J. Evans
I have just uploaded DBD::ODBC 1.31 to pause. This is the culmination of 7 development releases and I thought it was time to do an official release. Due to personal issues I am unlikely to be doing another update to DBD::ODBC in the near future but if you find issues please report them on RT

Re: Using MS Access 2007 with DBI

2011-06-29 Thread Martin J. Evans
My email client had a load of problems with your non-text email so I've not quoted it. I presume you are using DBD::ODBC? If not, I don't know. Could you provide a trace: set DBI_TRACE=15=x.log then run program and x.log should contain trace. Don't post it here, it is probably too long. If

Re: is it possible to use two sth from same dbh at the same time ?

2011-07-12 Thread Martin J. Evans
are using and then sometimes it depends on which driver you are using under that DBD. You'll need to tell us which DBD (and possibly driver) you are using. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: is it possible to use two sth from same dbh at the same time ?

2011-07-12 Thread Martin J. Evans
what is in the document referenced above. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: t/20SqlServer.t hangs on 61. Must break.

2011-07-13 Thread Martin J. Evans
but that is just a guess. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Help installing DBI

2011-07-17 Thread Martin J. Evans
On 16/07/2011 05:34, n...@kastle.org wrote: Hi, I want to interface my perl scripts with the MySQL dataBases. I'm running an Ubuntu Web Server - How can I test to see if DBI is installed and, if it's not, what's the process (or where can I find/read) to install both (if I

Re: DBD::Informix 2 test failures attempting to install AIX 5.3

2011-07-26 Thread Martin J. Evans
you with Informix itself but the maintainer might find it easier to diagnose the problem if you run prove -vb t/t32nulls and similarly on t61varchar as the output is more verbose. Martin snipped other info Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: perl-dbi #temp table created using handle not accessible when accessed via -do() with the same handle

2011-08-04 Thread Martin J. Evans
on this list, this question was first asked on stackoverflow at: http://stackoverflow.com/questions/6941197 I have provided and answer on stackoverflow and am awaiting a trace file. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD ODBC

2011-08-30 Thread Martin J. Evans
programs. 1/904 subtests failed. make: *** [test_dynamic] Error 255 Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD ODBC

2011-08-30 Thread Martin J. Evans
On 30/08/2011 13:05, Martin J. Evans wrote: On 23/08/11 17:12, Jason Lewis wrote: Checking if your kit is complete... Warning: the following files are missing in your kit: t/rt_68720.t Please inform the author. This is my fault and as soon as svn.perl.org and rt.perl.org are working again

Re: DBD ERROR: LOB refetch attempted for unsupported statement type

2011-09-03 Thread Martin J. Evans
On 03/09/2011 07:50, Shobha Deepthi V (sobv) wrote: Hi, I am calling a stored procedure that returns ref cursor from perl. But it fails with the following error, DBD::Oracle::st execute failed: ( DBD ERROR: LOB refetch attempted for unsupported statement type ) I searched for this

Re: DBD::Pg closes connection unexpectedly

2011-09-04 Thread Martin J. Evans
On 04/09/2011 03:58, Mr. Puneet Kishor wrote: On Sep 3, 2011, at 9:46 PM, David E. Wheeler wrote: On Sep 3, 2011, at 7:27 PM, Mr. Puneet Kishor wrote: I am on Mac OS X Lion with Pg 9.0.x, Perl 5.14.1, and the latest iterations of DBI and DBD::Pg. My code is pretty straightforward my

Request for help collating unicode support in DBDs

2011-09-27 Thread Martin J. Evans
I am attempting to run through as many DBDs as possible producing a list of those that support Unicode, how they support it (driver flags and caveats etc) and any issues with it. So far I'm working my way through DBD::SQLite, DBD::CSV, DBD::ODBC, DBD::Oracle and DBD::Pg (because those are ones

Re: Strange happenings in ODBC

2011-09-28 Thread Martin J. Evans
On 28/09/2011 20:41, Jeff Tate wrote: I am developing an app that pulls data from a Teradata data-server through DBI, DBD::ODBC. It is developed on a Win32 platform, but targeted for an AXI platform. In debugging a difference between the two platforms (after rigorous code identity

Re: Strange happenings in ODBC

2011-09-28 Thread Martin J. Evans
? That is, reduce the problem to something we don't need inside knowledge to understand and even better into a reproducible problem (although I appreciate this can be difficult and I've not got teradata anyway). Martin -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com

Re: Strange happenings in ODBC

2011-09-28 Thread Martin J. Evans
of comparing the output in AIX and Windows - what column names exist in either output that differ from what you selected. Martin -Original Message- From: Martin J. Evans [mailto:martin.ev...@easysoft.com] Sent: Wednesday, September 28, 2011 4:51 PM To: dbi-users@perl.org Cc: Jeff Tate Subject

Re: Strange happenings in ODBC

2011-09-29 Thread Martin J. Evans
On 28/09/11 22:26, Martin J. Evans wrote: On 28/09/2011 22:10, Jeff Tate wrote: 1) the versions of DBI and ODBC are the same on Windows and AIX 2) the program is identical on Windows and AIX. I develop on Windows and move to AIX for production. The two output fragments are from an identical

Re: Undefined $DBI::errstr on error using MySql on Windows-7-x64

2011-10-04 Thread Martin J. Evans
at: https://rt.cpan.org/Public/Bug/Display.html?id=71047 Also posted to StackOverflow: http://stackoverflow.com/questions/7432944/undefined-dbierrstr-using-dbi-perl-and-mysql-on-windows-7-x64 Thanks in advance, Tadhg Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Undefined $DBI::errstr on error using MySql on Windows-7-x64

2011-10-04 Thread Martin J. Evans
though the table does not exist. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com From: Martin J. Evansmartin.ev...@easysoft.com To: dbi-users@perl.org Sent: Tuesday, October 4, 2011 4:51 AM Subject: Re: Undefined $DBI::errstr on error using MySql

Re: DBD::ODBC fails, SQL*Plus works

2011-10-07 Thread Martin J. Evans
Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle 1.32 Compile Errors : Oracle.c: In function ‘XS_DBD__Oracle__db_ora_db_startup’ and more....help?

2011-10-21 Thread Martin J. Evans
DBD::Oracle. Please RT this at rt.cpan.org. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

New development release of DBD::ODBC (1.32_2)

2011-10-22 Thread Martin J. Evans
I have just uploaded 1.32_2 development release of DBD::ODBC. This contains one rather nice enhancement for Windows users which adds the new odbc_driver_complete attribute described as below. Any testing will be greatly appreciated. The full changes since 1.31 are: =head2 Changes in DBD::ODBC

Re: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-27 Thread Martin J. Evans
don't think there is a way right now. You'd need to add an attribute or 2 on the $dbh to return them. It is fairly easy and if you've done some XS already I doubt you'd have much problem. Just do a search for an attribute like ora_parse_error_offset. Martin -- Martin J. Evans Easysoft Limited

Re: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-27 Thread Martin J. Evans
++ libraries. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com Hope this helps Cheers John Date: Thu, 27 Oct 2011 09:48:54 -0400 From: bro...@deseret.com To: byter...@hotmail.com CC: dbi-users@perl.org Subject: Re: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh Yes, I

Re: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-28 Thread Martin J. Evans
ended up patching DBD::Oracle to do what I needed. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com Quoting Tim Bunce (tim.bu...@pobox.com): I'm late to this thread (it went into a different mail folder). Lyle, have you see the Oracle::OCI module? It provides deep

Re: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-28 Thread Martin J. Evans
it another go. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

New 1.32_3 dev release of DBD::ODBC - some Unicode changes

2011-11-15 Thread Martin J. Evans
J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle on RHEL5 [2.6.18-164.el5 albiet not really relevant] x86_64

2011-11-22 Thread Martin J. Evans
and twiddles for years of Oracle changes. I guess we need to edit that message in some way now to avoid it. client_version=11.2 DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\11.2.0.2\ -DORA_OCI_102 -DORA_OCI_112 Thanks for taking the time to report it. Martin -- Martin J. Evans

Re: Teradata using DBD::ODBC

2011-11-22 Thread Martin J. Evans
On 22/11/2011 08:48, Martin J. Evans wrote: On 21/11/11 18:51, Yang, Longjiang wrote: Hi, I use DBD::ODBC to connect to Teradata. I need to get column data type back. when using $sth-{TYPE}. I got IDs not in $dbh-type_info_all. It appears to happen to only CHAR and VARCHAR types. Does anyone

Re: Teradata using DBD::ODBC

2011-11-22 Thread Martin J. Evans
On 22/11/2011 18:57, Martin J. Evans wrote: On 22/11/2011 08:48, Martin J. Evans wrote: On 21/11/11 18:51, Yang, Longjiang wrote: Hi, I use DBD::ODBC to connect to Teradata. I need to get column data type back. when using $sth-{TYPE}. I got IDs not in $dbh-type_info_all. It appears

Re: Teradata using DBD::ODBC

2011-11-22 Thread Martin J. Evans
On 22/11/2011 19:02, Martin J. Evans wrote: On 22/11/2011 18:57, Martin J. Evans wrote: On 22/11/2011 08:48, Martin J. Evans wrote: On 21/11/11 18:51, Yang, Longjiang wrote: Hi, I use DBD::ODBC to connect to Teradata. I need to get column data type back. when using $sth-{TYPE}. I got IDs

New DBD::ODBC 1.33 release

2011-12-01 Thread Martin J. Evans
I've just uploaded DBD::ODBC 1.33 to CPAN. This release contains no new changes since the 1.32_5 development release but is the official release for all the 1.32 dev series. The complete changes can be found below. The main thrust has been Unicode improvements. The most significant

Problem with Oracle collections/objects

2011-12-09 Thread Martin J. Evans
-execute; my $r = $s-fetchall_arrayref; return $r; } Thanks Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Development release of DBD::ODBC with native execute_for_fetch support

2011-12-11 Thread Martin J. Evans
Hi, I have just uploaded DBD::ODBC 1.34_1 to CPAN. This release adds very experimental support for a native execute_for_fetch method to DBD::ODBC which means you can do multiple row inserts/updates/deletes much quicker than using DBI's default execute_for_fetch (so long as you are using

Re: Issue with DBD:Oracle 1.34 module on 64 bit Linux machine

2011-12-12 Thread Martin J. Evans
appeared to work so DBD::Oracle was ok at that point. The error you are getting looks like it resulted from running something else. Is your LD_LIBRARY_PATH still set to what it was when you built DBD::Oracle? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Problem with Oracle collections/objects

2011-12-13 Thread Martin J. Evans
. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com From: byter...@hotmail.com To: martin.ev...@easysoft.com; dbi-...@perl.org CC: dbi-users@perl.org Subject: RE: Problem with Oracle collections/objects Date: Tue, 13 Dec 2011 06:42:12 -0500 Well I am able to recreate it which

Re: More of an oracle question than dbi...

2012-01-11 Thread Martin J. Evans
instead of just the SQL. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Upgrading to Ubuntu 11.10

2012-01-15 Thread Martin J. Evans
On 13/01/2012 17:37, Rafael Muneton wrote: Hello everyone: I have an application where i use Perl, with Apache and MySQL on Ubuntu 11.04 and everything is working OK. But in the last few days I'm trying to upgrade my Ubuntu to the 11.10 Version and I cannot connect to the database, I'm getting

Re: What is the oldest community supported versions for PERL DBI and DBD::ORACLE?

2012-01-23 Thread Martin J. Evans
version is so different from the one you are using (code-wise) I doubt even if you found a bug which was still present in the newest release you'd persuade anyone to also fix it in 1.16. Perhaps you need to explain why you've asked the question. Martin -- Martin J. Evans Easysoft Limited http

Re: DBD::Oracle on OSX Lion (64-bit)

2012-01-25 Thread Martin J. Evans
remember it was Oracle 10gr2 so, yes 10.2.x.x was the problem. I don't believe 10.2 was certified on Lion and I don't think that situation has changed. I have updated the readme. Thanks. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Multiple Result Sets In A select Statement In Sybase

2012-02-03 Thread Martin J. Evans
-- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: Multiple Result Sets In A select Statement In Sybase

2012-02-03 Thread Martin J. Evans
Melillo joseph.meli...@moodys.com So you are using DBD::Sybase - i.e., the Sybase in 'dbi:Sybase:' tells DBI to load DBD::Sybase. As a result, all the Sybase specific stuff will be documented in DBD::Sybase. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: New DBD::ODBC 1.34_3 development release

2012-02-05 Thread Martin J. Evans
On 04/02/2012 20:51, Tim Bunce wrote: On Fri, Feb 03, 2012 at 08:51:10PM +, Martin J. Evans wrote: You should also be aware that calling odbc_getdiag* will clear DBI's err, errstr and state so if you want DBI's methods to return something meaningful you may need to call them first - I'm

Re: DBD::Oracle not utf8 encoding PL/SQL out values

2012-02-07 Thread Martin J. Evans
be on. BTW, that code originates from a patch in April 2002 so it is OLD code - http://www.mail-archive.com/dbi-users@perl.org/msg10046.html You should probably rt this at rt.cpan.org. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD::Oracle not utf8 encoding PL/SQL out values

2012-02-07 Thread Martin J. Evans
On 07/02/2012 19:42, Steve Baldwin wrote: Thanks a lot Martin. Created https://rt.cpan.org/Public/Bug/Display.html?id=74753. Cheers, Steve Could you post on the rt if you apply the patch and it works for you. Thanks Martin On Tue, Feb 7, 2012 at 8:28 PM, Martin J. Evans martin.ev

Re: DBD::Oracle not utf8 encoding PL/SQL out values

2012-02-09 Thread Martin J. Evans
On 07/02/12 09:28, Martin J. Evans wrote: On 07/02/12 04:56, Steve Baldwin wrote: #!/usr/bin/perl -w use strict; use warnings; use DBI; use Encode; sub main { my $dbh = DBI-connect( 'dbi:Oracle:', 'usr/pwd@instance', '', { PrintError = 0, AutoCommit = 0, RaiseError = 1, }, ); print {*STDERR

New DBD::ODBC 1.34_5 development release

2012-02-17 Thread Martin J. Evans
attributes odbc_batch_size and odbc_disable_array_operations. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

DBD::ODBC 1.35 released

2012-03-06 Thread Martin J. Evans
I've just uploaded DBD::ODBC 1.35 to CPAN. This is the culmination of 7 development releases in the 1.34 chain and is a significant release containing a lot of changes and enhancements. As always I would like to thank everyone who has helped and especially CPAN testers. The full list of

Re: DBD: postgres fail

2012-03-20 Thread Martin J. Evans
and if this is the most recent Postgres driver report it on rt. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

Re: DBD:Oracle compilation failure

2012-03-20 Thread Martin J. Evans
or Cygwin - does that file exist? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com

<    1   2   3   4   5   6   >