Re: :oracle 1.07 bug with oracle 7

2001-08-06 Thread Gerrit P. Haase
Am 6 Aug 2001, um 22:10 hat Tim Bunce geschrieben: > On Tue, Jul 24, 2001 at 01:44:12AM -0500, Stevenson, Jonathan wrote: > > There is a problem with DBD::Oracle 1.07 coneecting to Oracle 7. I > > sorted this issue with reference to an old post, but then just got > > another one, about missing sy

RE: Turning autocommit off

2001-08-06 Thread Neil Lunn
>-Original Message- >From: Jonathan Leffler [mailto:[EMAIL PROTECTED]] >Neil Lunn wrote: > >> It's off by defualt. But the documentation should help more here. > >Are you sure? I think you'll find it is on by default, >because that's the only >mode that all databases, even databases wit

Re: Turning autocommit off

2001-08-06 Thread Jonathan Leffler
Neil Lunn wrote: > It's off by defualt. But the documentation should help more here. Are you sure? I think you'll find it is on by default, because that's the only mode that all databases, even databases without transactions (eg DBD::CSV, unlogged Informix databases, older versions of MySQL, et

Re: :oracle 1.07 bug with oracle 7

2001-08-06 Thread Tim Bunce
On Mon, Aug 06, 2001 at 10:10:02PM +0100, Tim Bunce wrote: > On Tue, Jul 24, 2001 at 01:44:12AM -0500, Stevenson, Jonathan wrote: > > There is a problem with DBD::Oracle 1.07 coneecting to Oracle 7. I > > sorted this issue with reference to an old post, but then just got > > another one, about mis

[Patch] RE: DBD-ODBC 0.28 for Cygwin

2001-08-06 Thread Neil Lunn
>-Original Message- >From: Timothy C. Phan [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, August 07, 2001 6:20 AM >To: [EMAIL PROTECTED] >Subject: RE: DBD-ODBC 0.28 for Cygwin > > >Hi, > > I'm actually using ActiveState Perl for a couple of years now. > I, however, wanted to try diff versio

RE: Problem with DBD::Oracle8?

2001-08-06 Thread Sterin, Ilya
This came up two days ago. As I commented before this is sometimes the way windows handles error exits. Sometimes it will generate this error in a pop up box and sometimes it won't for the same script. Again this has to do with how windows handles error messages. Though what I still can't unde

Problem with DBD::Oracle8?

2001-08-06 Thread Stuart Pineo
Dear DBI Users, I have just installed DBD::Oracle8 on a Windows machine to address the handling of CLOBs. The CLOB issue appears to be solved but I now notice that whenever I get a unique contraint violation the program exits generating the message shown below followed by a windows popup error (a

RE: DBD-Oracle and Windows [again]: what else is needed?

2001-08-06 Thread Sterin, Ilya
You need to have client libs installed just as you do with any other database driver. If you install the Oracle client installation, which you can download from technet.oracle.com, then you should be all set, since SQL Net is a part of that install. You will then have to configure ORACLE_HOME, t

Re: Strange warning message from deep inside DBI

2001-08-06 Thread Tim Bunce
Yes, old debugging fluff. Ignore it (if you have set trace>=9). Tim. On Wed, Jul 25, 2001 at 11:44:23AM -0700, Wilson, Doug wrote: > That is a warning (thats supposed to be) issued only when the debug > level is set to 9 or higher. > > > -Original Message- > > From: Jeff Boes [mailto:[E

Re: :oracle 1.07 bug with oracle 7

2001-08-06 Thread Tim Bunce
On Tue, Jul 24, 2001 at 01:44:12AM -0500, Stevenson, Jonathan wrote: > There is a problem with DBD::Oracle 1.07 coneecting to Oracle 7. I > sorted this issue with reference to an old post, but then just got > another one, about missing symbols on the make perl step of a static > build, so you migh

Re: Win32::W32ODBC

2001-08-06 Thread Tim Bunce
Thanks. Tim. On Mon, Jul 23, 2001 at 12:43:24PM +0100, Peters, Andrew wrote: > Tim > > If you are interested, I have updated the W32ODBC module to include a few > more of the Win32::ODBC methods. > > The module provided the basis for a great solution to a memory leak problem > with Win32::ODBC

Re: DBI test, stack overflow

2001-08-06 Thread Tim Bunce
On Mon, Jul 23, 2001 at 02:15:26PM +0300, Jaakko Yli-Luukko wrote: > [root@netfinity DBI-1.19]# make test > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib >-I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness >qw(&runtests $verbose); $verbose=0; runtests @ARGV;'

RE: DBD-ODBC 0.28 for Cygwin

2001-08-06 Thread Timothy C. Phan
Hi, I'm actually using ActiveState Perl for a couple of years now. I, however, wanted to try diff version specially the one from Cygwin because I like the way Cygwin perl uses it own libraries instead of MS libs. I tried to build the DBD-ODBC and got a lot of compiler problem with th

RE: DBD-ODBC 0.28 for Cygwin

2001-08-06 Thread Sterin, Ilya
Why not ActivePerl, might I ask. As far as cygwin, it's hard to help without knowing what you arleady tried and what is failing. Shouldn't be a problem as long as you use the gcc that comes with cygwin, which was used to build perl.exe Ilya -Original Message- From: Timothy C. Phan To: [

[remain] DBD::Oracle install hangup

2001-08-06 Thread M. Jang
Dear dbi-users, Thanks to Hardy Merril, I could sort out Oracle.so load problm. But the 'perl Makefile.PL' step still gives error messages:- . Constant subroutine __need_size_t undefined at /usr/lib/perl5/5.00503/i386-linux/stddef.ph line 131 . WCOREDUMP not defined in wait.ph file and my 'mak

DBD-ODBC 0.28 for Cygwin

2001-08-06 Thread Timothy C. Phan
HI, Has anyone successfully build DBD-ODBC-0.28 in the Cygwin environment on Windows/NT? This is for Cygwin's perl. Please let me know what are the required steps, files, etc. Thanks! --- tcp

RE: $SIG{INT} - Is there a standard idiom?

2001-08-06 Thread Sterin, Ilya
Why do you want to call finish on them. Finish is almost never required, it's only used to either abort the current fetch process and deallocate some resources back to the system, like clearing the cache, etc... Ilya -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

$SIG{INT} - Is there a standard idiom?

2001-08-06 Thread djberge
Hi all, Is there a standard idiom for handling an interrupt signal with regards to DBI? Now, I know I can do: $dbh->rollback(), $dbh->disconnect(); What I would really like to do is get a reference to all statement handles that are currently active and call 'finish()' on them (or whatever would

RE: UTF8 data corrupted one insert of multi-language CLOBS in oracle 8.1.7

2001-08-06 Thread Orekhova, Irina
Try to set the enviromental variable NLS_LANG before executing your perl script (something like set NLS_LANG=AMERICAN_AMERICA.UTF8 ) -Original Message- From: Robert Foglia [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 2:22 PM To: '[EMAIL PROTECTED]' Subject: UTF8 data corr

Re: Fumbling towards connectivity

2001-08-06 Thread Thomas Good
On Mon, 6 Aug 2001, Hardy Merrill wrote: > Linking problems seem to be a popular topic lately - the problem > is that your installation can't find the Oracle libraries. Here's > a suggestion I found on this list that helped me solve the problem: Hello Hardy! Yes I like your approach as this is

Re: Placeholders when deleting

2001-08-06 Thread Ronald J Kimball
On Fri, Aug 03, 2001 at 10:26:20PM -0500, Mike Blezien wrote: > > >>On Fri, 3 Aug 2001 22:22:57 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: > > >>$selquery = qq|SELECT memid FROM optin WHERE time > NOW()|; > >>$sth = $dbh->prepare($selquery); > >>$delquery = qq|DELETE FROM members WHERE memi

Re: Fumbling towards connectivity

2001-08-06 Thread Hardy Merrill
Linking problems seem to be a popular topic lately - the problem is that your installation can't find the Oracle libraries. Here's a suggestion I found on this list that helped me solve the problem: * edit /etc/ld.so.conf and add a line for your Oracle lib directory - here's the line I add

Re: Oracle , Perl, connect failed

2001-08-06 Thread Hardy Merrill
I *don't* have experience with this on Windows, but I assume you can still use "sqlplus" - can you connect to the database using sqlplus? If you can connect to the database using sqlplus then that proves that the Oracle networking files are set up correctly - if not, then attend to that(setting u

Re: DBD::Oracle install err in Oracle 8.1.6

2001-08-06 Thread Hardy Merrill
It's been a while since I installed DBD::Oracle, but here's what I remember: 1. make sure you can connect to Oracle using sqlplus - note the oracle user used to connect 2. edit "/etc/ld.so.conf" and add a line for the Oracle library directory - here is the line I added to that file

DBD-Oracle and Windows [again]: what else is needed?

2001-08-06 Thread Siiskonen, Pekka
Please inform me: In Windows enviroment what else should be installed besides perl, v5.6.1 built for MSWin32-x86-multi-thread (build 626) DBD-ODBC [0.28 ] ODBC driver for the DBI module. DBD-Oracle [1.06 ] Oracle database driver for the DBI module DBD-Orac

Internalization of DBI scripts ...

2001-08-06 Thread Sumit_Babu
Hi, I would like to know what are the steps/precaution that are required to be taken while writing a DBI application. I am working on a project that requires internalization of DBI script which extracts data from a Oracle database, and generates SQLLoad files from these. The following is th