DBD::Oracle installation problem

2003-11-06 Thread DONNETTE Benoit (EXT)
I am trying to get the DBD::Oracle module compile, but it keeps complaining about OCI directory not found. I am using Perl 5.8.0, downloaded the latest DBI as of yesterday, this one compiled and tested OK, but using Oracle client 9.2, I couldn't get the DBD compile. I am not admin of the WinXP

Re: Field terminated by

2003-11-06 Thread Hardy Merrill
First, I think you are probably correct - I don't think you need the semi-colon terminating the command when you're submitting your command via DBI. So try removing the ";" that you have after the "(ID)". Second, this is just a shot-in-the-dark (because I really don't know what the problem is) bu

Antwort: Re: Field terminated by

2003-11-06 Thread Stefan . Skopnik
I think the "load" command is not a valid SQL-command. It is an command extention provided by the DBMS So it can't be used via DBI. I had the same problem long ago, trying to unload a table using an ODBC-Driver connection in a C++ programm. It simply didn't work ;-) I had to use a special bulk in

Re: Field terminated by

2003-11-06 Thread Tim Bunce
On Wed, Nov 05, 2003 at 11:47:46PM +0100, W. Bauer wrote: > Dear all > > I have a problem using special characters in the Perl DBI. The following > SQL code works without problem with mysql: > > load data local infile "orders.txt" > into table orders > fields terminated

Re: possible memory leak in either DBI or DBD:Oracle (or maybe oci??)

2003-11-06 Thread Tim Bunce
On Wed, Nov 05, 2003 at 03:15:40PM +0100, Roman Hochleitner wrote: > > Hi! > > We are using Oracle 8.1.7 server/client under Redhat 7.1 perl 5.6.0 with > DBD::Oracle V1.14 and DBI V1.37. > > With the attached script I can reproduce a memory leak growing at a rate > of about 12MB/min. We use scr

RE: ppm for DBD::Oracle

2003-11-06 Thread Jeff Urlwin
Paul, Mine is for 5.8.x Jeff > > I know this keeps coming up but... does anyone know of a > location of a ppm for > DBD::Oracle for 5.8.0? None of the repositories I've checked > (Jeff's, Randy > Kobe's, the one at PerlMonks) seem to have it available. > > I ran into a computer on which O

Re: Field terminated by

2003-11-06 Thread W. Bauer
> And from http://search.cpan.org/~rudy/DBD-mysql-2.9003/lib/DBD/mysql.pm > > mysql_local_infile > > As of MySQL 3.23.49, the LOCAL capability for LOAD DATA may be > disabled in the MySQL client library by default. If your DSN > contains the option "mysql_local_infile=1", LOAD DATA

Re: Field terminated by

2003-11-06 Thread Paul DuBois
At 19:04 +0100 11/6/03, W. Bauer wrote: > And from http://search.cpan.org/~rudy/DBD-mysql-2.9003/lib/DBD/mysql.pm mysql_local_infile As of MySQL 3.23.49, the LOCAL capability for LOAD DATA may be disabled in the MySQL client library by default. If your DSN contains the option "m

Re: Field terminated by

2003-11-06 Thread Rudy Lippan
On Thu, 6 Nov 2003, Paul DuBois wrote: > At 19:04 +0100 11/6/03, W. Bauer wrote: > > > And from http://search.cpan.org/~rudy/DBD-mysql-2.9003/lib/DBD/mysql.pm > >> > >>mysql_local_infile > >> > >> As of MySQL 3.23.49, the LOCAL capability for LOAD DATA may be > >> disabled in the My

DBD::ORACLE Hanges

2003-11-06 Thread Kenneth Webber
Friends. When I attempt to install the DBD::ORACLE modual it hangs after one line of output. I have installed several other modules including DBI with out problems. Has anyone seen this. This is what I get logger] DBD-Oracle-1.14> perl Makefile.PL Using DBI 1.38 installed in /usr/local/lib/p