Re: Need help in compilation of DBI.c

2005-08-19 Thread Jonathan Leffler
On 8/18/05, manas sahu <[EMAIL PROTECTED]> wrote: > I am trying to build and install DBI module. I have built and installed > perl Version 5.8.7. The compiler gives the following errors; > > > "DBI.c", line 3577: Error: Unexpected type name "SV" encountered. > "DBI.c", line 3577: Error: Operand

Re: Can not install/compile DBI/DBD on AIX 5.3 or AIX 5.2

2005-08-19 Thread Jonathan Leffler
Don't use the preinstalled (and archaic) version of Perl -- build and install your own Perl version 5.8.7? Personally, I never modify the o/s installed Perl; I always use my own version. I don't have to use root privileges to add to the installation. I don't have to worry about whether I'll brea

Memoizing non-place-holding sql statements to place-holding

2005-08-19 Thread h-taguchi
Hello, Is there a module already existing to memoize non-place-holding sql statements to place-holding ones and suppress prepare to minimum? I'm now transforming other peaple's scripts for a performance inprovement. This system is so big, I cann't understand quickly, but I foud that all SQL state

Re: FW: Failed DBD Oracle 1.16 make on Perl 5.8.6, DBI 1.48, Oracle 9.2.0.6, Solaris 8.

2005-08-19 Thread Scott T. Hildreth
Have they installed the Oracle's ProC product? Did they post to the dbi-users list? On Fri, 2005-08-19 at 15:01 -0400, Chiang, William T wrote: > > > > See below link, many people in many companies complained they have problem > > to install DBD. I am surprised no one provided answer. > > http:/

FW: Failed DBD Oracle 1.16 make on Perl 5.8.6, DBI 1.48, Oracle 9.2.0.6, Solaris 8.

2005-08-19 Thread Chiang, William T
> See below link, many people in many companies complained they have problem > to install DBD. I am surprised no one provided answer. > http://www.cpanforum.com/threads/698 >

Re: DBD::Oracle - prepare() and the utf-8 flag - revisited

2005-08-19 Thread Tim Bunce
On Fri, Aug 19, 2005 at 01:52:54PM +0100, Charles Jardine wrote: > Tim Bunce wrote, on 17/08/2005 21:23: > > >If the $statement is UTF8 then simply tell Oracle that it's UTF8. > >Simple. > > Unfortunately this isn't as easy as it is when binding. OCI > statement handles do not support OCI_ATTR_CH

Re: DBD::Oracle - prepare() and the utf-8 flag.

2005-08-19 Thread Charles Jardine
Tim Bunce wrote, on 17/08/2005 21:23: On Wed, Aug 17, 2005 at 06:01:03PM +0100, Charles Jardine wrote: Tim Bunce wrote, on 15/08/2005 14:36: On Mon, Aug 15, 2005 at 12:07:03PM +0100, Charles Jardine wrote: This what I am proposing for prepare. It already happens for values sent of returned

RE: [dbi] DBD::Oracle, Instantclient and HP-UX...

2005-08-19 Thread michael . peppler
Hi Lincoln, Thanks for the advice. Yes, I did build my own copy of perl (5.8.7), and the build itself appears fine - certainly there are no missing symbols, etc. in the Oracle.sl file, and the DBD::Oracle module loads correctly. Like I said the problem appears to be with the initialization (OCIE

RE: [dbi] DBD::Oracle, Instantclient and HP-UX...

2005-08-19 Thread Lincoln A. Baxter
Tree setting SHLIB_PATH to the same value as LD_LIBRARY_PATH. Try doing this before you build DBD::Oracle. (You are doing this with a perl you have built right?) If/when you get it work, try patching Makefile.PL to find the libraries and includes so that it builds the right Makefile, if you get t

Re: Bulk Inserts

2005-08-19 Thread Tim Bunce
On Thu, Aug 18, 2005 at 12:29:06PM +0200, Peter J. Holzer wrote: > On 2005-08-16 14:22:26 +0100, Tim Bunce wrote: > > On Tue, Jul 19, 2005 at 12:58:59PM +0200, Peter J. Holzer wrote: > > > On 2005-07-19 14:49:57 +0530, Kiran Kumar wrote: > > > > We could have an option to do Bulk Inserts .. > > >

RE: [dbi] DBD::Oracle, Instantclient and HP-UX...

2005-08-19 Thread michael . peppler
Thanks Martin, Unfortunately unsetting ORACLE_HOME didn't fix that problem (i.e. OCIEnvCreate still fails). Michael Extranet [EMAIL PROTECTED] - 19/08/2005 10:43 To: dbi-users cc: Subject:RE: [dbi] DBD::Oracle, Instantclient and HP-UX... Michael, I think with InstantClien

RE: [dbi] DBD::Oracle, Instantclient and HP-UX...

2005-08-19 Thread Martin J. Evans
Michael, I think with InstantClient OCIEnvCreate fails if you set ORACLE_HOME. You need to make sure libclntsh.so is on your dynamic linker search path (LD_LIBRARY_PATH) and do /not/ set ORACLE_HOME. Martin -- Martin J. Evans Easysoft Ltd, UK Development On 19-Aug-2005 [EMAIL PROTECTED] wrote:

DBD::Oracle, Instantclient and HP-UX...

2005-08-19 Thread michael . peppler
Hi, I'm not exactly new to DBI, but I am *very* new to Oracle, so please bear with me... I'm trying to build DBD::Oracle on an HP-UX (11.11) box with the 32bit instantclient package, and while the build works the make test fails, and my googling has failed to turn up any solutions. I've patch