Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-05-07 Thread Peter J. Holzer
On 2008-05-05 10:46:05 -0700, pgodfrin wrote: My install of Oracle, for reasons unknown to me, had this file set to rwxr-x--- which doesn't work for 'others'. In recent versions of Oracle, by default the programs and libraries installed with a server installation are only usable by the DBA

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-05-06 Thread pgodfrin
On May 2, 1:51 pm, [EMAIL PROTECTED] (Jared Still) wrote: On Fri, 2008-04-25 at 09:08 -0700, Dunston Rocks wrote: $ENV{TNS_ADMIN}= 'C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnam es.ora'; # Also tried replacing these with POSIX-Style paths $ENV{ORACLE_HOME} =

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-05-02 Thread Jared Still
On Fri, 2008-04-25 at 09:08 -0700, Dunston Rocks wrote: $ENV{TNS_ADMIN}= 'C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnam es.ora'; # Also tried replacing these with POSIX-Style paths $ENV{ORACLE_HOME} = C:\oracle\product\10.2.0\client_2; $ENV{NLS_LANG} =

Building DBD::Oracle on XP w/ VC 2005

2008-05-01 Thread Gerber, Christopher J
First off, I am new to the list. If there is a FAQ, feel free to point me there! This morning I built DBD-Oracle-1.21 on my XP machine using Visual Studio 2005. After building, I needed to copy the redistributable files to blib/arch/auto/DBD/Oracle, and I needed to embed the manifest

Re: Building DBD::Oracle on XP w/ VC 2005

2008-05-01 Thread John Scoles
to the list. If there is a FAQ, feel free to point me there! This morning I built DBD-Oracle-1.21 on my XP machine using Visual Studio 2005. After building, I needed to copy the redistributable files to blib/arch/auto/DBD/Oracle, and I needed to embed the manifest

RE: Building DBD::Oracle on XP w/ VC 2005

2008-05-01 Thread Gerber, Christopher J
-Oracle-1.21 on my XP machine using Visual Studio 2005. After building, I needed to copy the redistributable files to blib/arch/auto/DBD/Oracle, and I needed to embed the manifest into Oracle.dll with the following command: mt.exe -manifest Oracle.dll.manifest -outputresource:Oracle.dll;2

Re: Building DBD::Oracle on XP w/ VC 2005

2008-05-01 Thread John Scoles
I will CC this one to a contact I have at Oracle as the first question Oracle suport will as is what it DBD::Oracle??? followed by we don't support it. If you do follow up say the execute array dose not work as expected. and that it works in 9. cheers John Scoles Gerber, Christopher J

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-04-30 Thread Christian Merz
Hi Dunston, the problem could the DBD::Oracle installation. Do you have multiple Oracle installations on your box? If not: you could reinstall DBI and DBD::Oracle and make sure that your Oracle environment is set correctly. Are/Were there any errors during the installation? If you have

RE: Error - DBD::Oracle / ORA-1008 problem with placeholders

2008-04-30 Thread pmonschein
d'origine- De : John Scoles [mailto:[EMAIL PROTECTED] Envoyé : mardi 29 avril 2008 17:12 À : MONSCHEIN,PASCAL Cc : dbi-users@perl.org Objet : Re: Error - DBD::Oracle / ORA-1008 problem with placeholders Can you give me what the table schema is? I would like to know what datatypes col1,col2

Re: Error - DBD::Oracle / ORA-1008 problem with placeholders

2008-04-30 Thread John Scoles
it doesn't look quite right cheers John Scoles [EMAIL PROTECTED] wrote: Hello all, I encouter an error with DBD::Oracle and Oracle instances 10g that I dont understand : DBD::Oracle::st execute failed: ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute) This script works fine

Error - DBD::Oracle / ORA-1008 problem with placeholders

2008-04-29 Thread pmonschein
Hello all, I encouter an error with DBD::Oracle and Oracle instances 10g that I dont understand : DBD::Oracle::st execute failed: ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute) This script works fine with Oracle 9i. I compiled DBD::Oracle (1.19) based on Oracle 9i (on Sun

Re: Error - DBD::Oracle / ORA-1008 problem with placeholders

2008-04-29 Thread John Scoles
[EMAIL PROTECTED] wrote: Hello all, I encouter an error with DBD::Oracle and Oracle instances 10g that I dont understand : DBD::Oracle::st execute failed: ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute) This script works fine with Oracle 9i. I compiled DBD::Oracle (1.19) based

Problems with bind variables with DBD::Oracle 1.21 on Leopard (MacOSX 10.5.2)

2008-04-28 Thread Matthew Ragan
With Oracle having finally come out with native Intel drivers for MacOS, I tried to install these to get rid of having to use a Rosetta- ized version of perl to run Oracle things through, but kept running into a problem where sometimes bind variables would work, and sometimes I would get

Re: Problems with bind variables with DBD::Oracle 1.21 on Leopard (MacOSX 10.5.2)

2008-04-28 Thread scoles
This was reported just a few days ago on rt cpan http://rt.cpan.org/Public/Bug/Display.html?id=35353 I fixed it and checked it in. It will be in release 1.22 of DBD::Oracle cheers John Scoles With Oracle having finally come out with native Intel drivers for MacOS, I tried to install

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-04-25 Thread Dunston Rocks
] Cc: dbi-users@perl.org Sent: Thursday, April 24, 2008 3:38:12 AM Subject: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin Hello Dunston, did you read perldoc DBI and perldoc DBD::Oracle ? To detect if DBI is able to locate DBD::Oracle use

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-04-24 Thread Christian Merz
Hello Dunston, did you read perldoc DBI and perldoc DBD::Oracle ? To detect if DBI is able to locate DBD::Oracle use: @driver_names = DBI-available_drivers; If so, you can idenitfy your oracle Instances via: @data_sources = DBI-data_sources($driver_name, \%attr

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-04-24 Thread Dunston Rocks
Rocks schrieb: Hi I had posted a few days ago about facing problems installing DBD::Oracle with Oracle 10g client under Cygwin. Though those were circumvented successfully, when I try to run a simple script that calls DBI-Connect, I get DBI connect() failed: ERROR OCIEnvNlsCreate. Check

OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-04-23 Thread Dunston Rocks
Hi I had posted a few days ago about facing problems installing DBD::Oracle with Oracle 10g client under Cygwin. Though those were circumvented successfully, when I try to run a simple script that calls DBI-Connect, I get DBI connect() failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env

Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin

2008-04-23 Thread Christian Merz
a few days ago about facing problems installing DBD::Oracle with Oracle 10g client under Cygwin. Though those were circumvented successfully, when I try to run a simple script that calls DBI-Connect, I get DBI connect() failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings

Re: DBD::Oracle and Support for Oracle 8 and 9 clients

2008-04-23 Thread Jared Still
On Thu, 2008-04-17 at 21:43 -0400, [EMAIL PROTECTED] wrote: I just want to get a general feeling of the community on weather the next version of DBD::Oracle (1.22) should drop support for the Oracle 8 and Oracle 9 clients Though personally I no longer have an 7.x databases to work

Re: DBD::Oracle and Support for Oracle 8 and 9 clients

2008-04-18 Thread Christian Merz
to support Oracle V8/V9 in new DBD releases. (Surely, the desupport will be outlined in the README...) Thank you, Christian [EMAIL PROTECTED] schrieb: I just want to get a general feeling of the community on weather the next version of DBD::Oracle (1.22) should drop support for the Oracle 8

Re: DBD::Oracle and Support for Oracle 8 and 9 clients

2008-04-18 Thread Eugene Krivdyuk
2008/4/17, [EMAIL PROTECTED] [EMAIL PROTECTED]: I just want to get a general feeling of the community on weather the next version of DBD::Oracle (1.22) should drop support for the [... skipped ...] Basically what I would like to know who uses what clients. I'm using Oracle 9i in some large

Re: DBD::Oracle and Support for Oracle 8 and 9 clients

2008-04-18 Thread Peter J. Holzer
On 2008-04-17 21:43:27 -0400, [EMAIL PROTECTED] wrote: I just want to get a general feeling of the community on weather the next version of DBD::Oracle (1.22) should drop support for the Oracle 8 and Oracle 9 clients I was just reviewing the code today and there are a large number

Re: DBD::Oracle and Support for Oracle 8 and 9 clients

2008-04-18 Thread John D Groenveld
/collateral/lifetime-support-coverage-chart.pdf That's not a cry for DBD::Oracle support moving forward as I'm mostly dealing with more recent Instance Client. John [EMAIL PROTECTED]

Trouble installing DBD::Oracle on Cygwin

2008-04-17 Thread Dunston Rocks
Hi I am having trouble installing DBD::Oracle on Cygwin Steps followed : Download from CPAN tar –zxvf DBD-Oracle-1.20.tar.gz cd DBD-Oracle-1.20 make realclean perl Makefile.pl make : *** [ Oracle.o ] Error 1 ; output attached (make_results.txt) perl – V (attached

DBD::Oracle and Support for Oracle 8 and 9 clients

2008-04-17 Thread scoles
I just want to get a general feeling of the community on weather the next version of DBD::Oracle (1.22) should drop support for the Oracle 8 and Oracle 9 clients I was just reviewing the code today and there are a large number of little fixes here and there to make these two clients work

Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
either an LD_LIBRARY_PATH environment variable or the ld.so.conf.d method, DBD does not run. I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were complicated by the fact that I was running it as a CGI script

Re: question for DBD-Oracle driver

2008-04-10 Thread pgodfrin
, without either an LD_LIBRARY_PATH environment variable or the ld.so.conf.d method, DBD does not run. Any thoughts? pg I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were complicated by the fact that I was running

Re: question for DBD-Oracle driver

2008-04-10 Thread James H. McCullars
At 02:17 AM 4/10/2008, Peter J. Holzer wrote: I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were complicated by the fact that I was running it as a CGI script and thus did not have a way to easily set

Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: At 02:17 AM 4/10/2008, Peter J. Holzer wrote: I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were complicated by the fact that I was running it as a CGI script

Re: question for DBD-Oracle driver

2008-04-10 Thread Ulisses Reina Montenegro de Albuquerque
On Thu, 2008-04-10 at 16:08 +0200, Peter J. Holzer wrote: On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: At 02:17 AM 4/10/2008, Peter J. Holzer wrote: I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were

Re: question for DBD-Oracle driver

2008-04-10 Thread James H. McCullars
At 09:08 AM 4/10/2008, Peter J. Holzer wrote: Why shouldn't it work with a CGI script? I can think of reasons why it wouldn't work with mod_perl, but none for a CGI script. Setting the environment variable worked for me from the command line but never from a CGI script. The best

Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
On 2008-04-10 10:26:50 -0500, James H. McCullars wrote: At 09:08 AM 4/10/2008, Peter J. Holzer wrote: Why shouldn't it work with a CGI script? I can think of reasons why it wouldn't work with mod_perl, but none for a CGI script. Setting the environment variable worked for me from the

RE: question for DBD-Oracle driver

2008-04-09 Thread Capacio, Paula J
On March 28, Icheng said: After I try the command you provide, I got the following error Can't load '/opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at /opt/perl5/lib/5.8.0/PA-RISC2.0/DynaLoader.pm line 229. at test_dbd_ver.pl

RE: question for DBD-Oracle driver

2008-04-09 Thread Capacio, Paula J
On March 28, Fred Vachon said: I have DBI and DBD::Oracle installed on a Solaris 10 machine. When I run either of the 2 commands that were posted I error out with: perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' Can't load '/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBD/Oracle

Re: question for DBD-Oracle driver

2008-04-09 Thread pgodfrin
On Apr 9, 10:04 am, [EMAIL PROTECTED] (Paula J Capacio) wrote: On March 28, Fred Vachon said: I have DBI and DBD::Oracle installed on a Solaris 10 machine. When I run either of the 2 commands that were posted I error out with: perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' Can't load

Re: question for DBD-Oracle driver

2008-04-09 Thread James H. McCullars
or the ld.so.conf.d method, DBD does not run. Any thoughts? pg I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were complicated by the fact that I was running it as a CGI script and thus did not have a way to easily set an environment

Re: question for DBD-Oracle driver

2008-04-08 Thread pgodfrin
On Mar 28, 2:05 pm, [EMAIL PROTECTED] (Frederick P A5IT Vachon) wrote: Hi - I have an issue related to this. I have DBI and DBD::Oracle installed on a Solaris 10 machine. When I run either of the 2 commands that were posted I error out with the messages listed below. perl -e 'use DBD

Re: question for DBD-Oracle driver

2008-04-08 Thread pgodfrin
On Mar 28, 2:05 pm, [EMAIL PROTECTED] (Frederick P A5IT Vachon) wrote: Hi - I have an issue related to this. I have DBI and DBD::Oracle installed on a Solaris 10 machine. When I run either of the 2 commands that were posted I error out with the messages listed below. perl -e 'use DBD

Re: ANNOUNCE: DBD::Oracle 1.21 Release Candidate 4

2008-04-07 Thread scoles
-oracle/trunk/DBD-Oracle-1.21-RC4.tar Still would like to see some more testing of this RC. Cheers John Scoles

Re: error during DBD::Oracle installation (was: error during DBI installation)

2008-04-02 Thread Jonathan Leffler
, haven't you?) So, which part of that is too hard to understand? You're running on ancient Solaris (2.6 - not supported), and you have a fairly old version of Oracle client -- did you check whether it is supported. And DBD does not mean DBD::Oracle - there are lots of DBD::DBMS drivers. On Wed, Apr

DBD::Oracle Easy question for some?

2008-04-01 Thread Russel Kropp
on the database but temp tables are ok. eg below I want to end up being able to bind to :test to fetch my results, but I want to be able to prepare and execute the below in one go. .. Thanks in advance for any help... This works in sqlplus in the one statement but DBD Oracle is spitting the dummy

Re: strange DBD::Oracle problem via dbi_link

2008-04-01 Thread Christian Merz
, not client) It seems, DBD::Oracle.pm failes to get environment variables to $ENV, so I fixed it to fallback to constant values. Everything failes on DBD::Oracle::dr sub connect, function DBD::Oracle::_login(..); It seems DBD::Oracle::_login is not a perl function, but rather an export from DBD

Re: strange DBD::Oracle problem via dbi_link

2008-04-01 Thread Giedrius Liubavičius
PgSQL user, database, query (and so DSN) on the localhost gets passed. (Query to DBI is executed from PostgreSQL server, not client) It seems, DBD::Oracle.pm failes to get environment variables to $ENV, so I fixed it to fallback to constant values. Everything failes on DBD::Oracle::dr sub connect

DBD::Oracle accessing Global Temporary Tables in PL/SQL.

2008-04-01 Thread rk_lj
on the database but temp tables are ok. eg below I want to end up being able to bind to :test to fetch my results, but I want to be able to prepare and execute the below in one go. .. Thanks in advance for any help... This works in sqlplus in the one statement but DBD Oracle is seeing :test

question for DBD-Oracle driver

2008-03-28 Thread ili
Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for DBI ? If we have already install DBD-Oracle, how can we check what version it is ? We have the unix (HP-UX houux14 B.11.11 U 9000/800 196921507 unlimited-user license) installed, and perl version ( v5.8.0

Re: question for DBD-Oracle driver

2008-03-28 Thread John Scoles
give this a try #!perl -w use DBI; use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI().\n; if you dbi is 1.47 you can use up to DBD::Oracle 1.19 cheers John Scoles [EMAIL PROTECTED] wrote: Dear sir/madam, How can we tell that we have already install DBD-Oracle drive

Re: question for DBD-Oracle driver

2008-03-28 Thread John Scoles
[EMAIL PROTECTED] wrote: Thank you so much for providing me this information. After I try the command you provide, I got the following error message. Can't load '/opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at /opt

Re: question for DBD-Oracle driver

2008-03-28 Thread Martin Evans
[EMAIL PROTECTED] wrote: Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for DBI ? perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' which will error with Can't locate DBD::Oracle... if you haven't got it. If we have already install DBD-Oracle, how

RE: question for DBD-Oracle driver

2008-03-28 Thread Ian Harisay
perl -e 'use DBD::Oracle 42' This will tell you what version is currently installed. Generally, I always refer to the man page first. But, I didn't see versioning info available in the DBD::Oracle man page. Probably an oversite on my part. -Original Message- From: John Scoles

RE: question for DBD-Oracle driver

2008-03-28 Thread Vachon, Frederick P (Fred) A5IT
Hi - I have an issue related to this. I have DBI and DBD::Oracle installed on a Solaris 10 machine. When I run either of the 2 commands that were posted I error out with the messages listed below. perl -e 'use DBD::Oracle 42' perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' I'm thinking

strange DBD::Oracle problem via dbi_link

2008-03-28 Thread giedrius . liubavicius
server, not client) It seems, DBD::Oracle.pm failes to get environment variables to $ENV, so I fixed it to fallback to constant values. Everything failes on DBD::Oracle::dr sub connect, function DBD::Oracle::_login(..); It seems DBD::Oracle::_login is not a perl function, but rather an export

Library not found errors with DBD-Oracle-1.20

2008-03-18 Thread James H. McCullars
Hi, I have successfully installed the Oracle instant client, DBI-1.602 and DBD-Oracle 1.20 and can connect to a database on a remote host, but only if I set LD_LIBRARY_PATH to the directory where the instant client is installed. This is fine, but I need to do this from a CGI script

Re: Library not found errors with DBD-Oracle-1.20

2008-03-18 Thread John Scoles
this when you la -a libclntsh.so - libclntsh.so.10.1 Just a thought cheers john scoles James H. McCullars wrote: Hi, I have successfully installed the Oracle instant client, DBI-1.602 and DBD-Oracle 1.20 and can connect to a database on a remote host, but only if I set LD_LIBRARY_PATH

Re: Library not found errors with DBD-Oracle-1.20

2008-03-18 Thread rahed
[EMAIL PROTECTED] (James H. McCullars) writes: Hi, I have successfully installed the Oracle instant client, DBI-1.602 and DBD-Oracle 1.20 and can connect to a database on a remote host, but only if I set LD_LIBRARY_PATH to the directory where the instant client is installed. This is fine

Re: DBD::Oracle - execute_array core dumps intermittently [SOLVED]

2008-03-14 Thread Martin Evans
execute_array() method was used. All of our servers have Oracle 10.2.0.3 so there wasn't a difference there and it didn't seem to matter if DBD::Oracle was 1.19 or 1.20. We basically decided that this was race problem with the threads, especially since it was an intermittent problem. I decided

Re: DBD::Oracle - execute_array core dumps intermittently [SOLVED]

2008-03-13 Thread Scott T. Hildreth
was used. All of our servers have Oracle 10.2.0.3 so there wasn't a difference there and it didn't seem to matter if DBD::Oracle was 1.19 or 1.20. We basically decided that this was race problem with the threads, especially since it was an intermittent problem. I decided to compile a DBD

Re: DBD::Oracle - execute_array core dumps intermittently

2008-03-07 Thread Scott T. Hildreth
it to core dump. All 3 servers have the same kernel Perl versions. I've tried recompiling Perl, DBI, DBD::Oracle, still no luck. I created a test case, which uses execute_array and of course I can't get it to core dump. If anyone has any ideas on what might be going on here, I would love to hear them

Re: DBD::Oracle - execute_array core dumps intermittently

2008-03-07 Thread Scott T. Hildreth
it from a third sever and I can't get it to core dump. All 3 servers have the same kernel Perl versions. I've tried recompiling Perl, DBI, DBD::Oracle, still no luck. I created a test case, which uses execute_array and of course I can't get it to core dump. If anyone has any ideas on what

Issues in Installing DBD-Oracle module.

2008-02-22 Thread Nirmaladevi Venkataraman
Hi all, I am using Active Perl5.8.8 (build 820) and Oracle client( 9i). I have got DBI package already installed.If I want to install DBD-Oracle,what is the process I need to follow. I tried using PPMppm install DBD-Oracle.Since I have firewall settings,I could

Re: Issues in Installing DBD-Oracle module.

2008-02-22 Thread scoles
820) and Oracle client( 9i). I have got DBI package already installed.If I want to install DBD-Oracle,what is the process I need to follow. I tried using PPMppm install DBD-Oracle.Since I have firewall settings,I could not connect to ppm.activestate.com. I have

Re: Issues in Installing DBD-Oracle module.

2008-02-22 Thread G Sreenivas Reddy
proxy setting: set http_proxy=http://username:[EMAIL PROTECTED] and install DBD-Oracle ppm install DBD-Oracle if already installed remove ppm remove DBD-Oracle regards gsreddy Nirmaladevi Venkataraman wrote: Hi all, I am using Active Perl5.8.8 (build 820) and Oracle client( 9i

Re: Issues in Installing DBD-Oracle module.

2008-02-22 Thread Lamb Joseph
Nirmala, Did you read and try the readme notes? http://cpan.uwinnipeg.ca/htdocs/DBD-Oracle/README.html What questions do you have about this processes? Joseph Lamb - Original Message From: Nirmaladevi Venkataraman [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Thursday, February 21

Re: Issues in Installing DBD-Oracle module.

2008-02-22 Thread Lamb Joseph
Another way is to download an old ppd file from activestate. http://ppm.activestate.com/PPMPackages/zips/8xx-builds-only/Windows/DBD-Oracle-1.17.zip Then expand the zip file. Next run ppm install i.e. ppm install C:\path\to\DBD-Oracle-1.17\DBD-Oracle.ppd - Original Message From

DBD::Oracle::st fetchrow_hashref warning when fetching multiple records from the table.

2008-02-12 Thread alias . abi
Hello, I am getting a warning like DBD::Oracle::st fetchrow_hashref warning: (err=0, errstr=undef, state=undef) [for Statement SELECT item.nreference, item.chold, item.npieces, item.nweight, item.ncube, item.cshippername, item.cwarehouselocation

Re: DBD::ORACLE INSTALLATION ERROR

2008-02-05 Thread Jared Still
On Mon, 2008-02-04 at 16:52 +0530, Mohammed, Shafi wrote: Hello, I am trying to install DBD::oracle package in my machine. Version? Please tell me how to resolve this issue. I know nothing about hpux, do have extensive experience perusing documentation. A good start would

DBD::ORACLE INSTALLATION ERROR

2008-02-04 Thread Mohammed, Shafi
Hello, I am trying to install DBD::oracle package in my machine. But I am getting continous error. I have installed perl 5.8.8 in my machine. Oracle client is also installed and it is working fine. DBI 1.51 also I have installed successfully. This configuration also I have

DBD-Oracle 1.20 - problems compiling on Windows (Visual Studio 2005 Perl 5.10)

2008-02-02 Thread Robert Mundkowsky
Hi, If anyone has a pre-built DBD-Oracle for Windows (XP/Pro)/Perl 5.10, would love to have it. R - * Notice: This e-mail

RE: DBD-Oracle 1.20 - problems compiling on Windows (Visual Studio 2005 Perl 5.10)

2008-02-02 Thread John Scoles
Unfortunately that would be unlawful. Oracle does not allow 3rd parties to bundle their software. Check out the Readmewin.txt it has a very good tutorial on how to compile for windows. Subject: DBD-Oracle 1.20 - problems compiling on Windows (Visual Studio 2005 Perl 5.10) Date: Fri, 1

Re: ppm install failed for DBD-Oracle because it can't find the package

2008-02-01 Thread Richard T Malafa
. Dan King [EMAIL PROTECTED] 01/31/2008 11:26 AM To dbi-users@perl.org cc Subject ppm install failed for DBD-Oracle because it can't find the package Hi there, I am attempting to install DBD-Oracle using ppm 4.0 on a Windows XP computer that has ActiveState version 5.8.8 installed

Re: ppm install failed for DBD-Oracle because it can't find the package

2008-01-31 Thread Eugene Krivdyuk
2008/1/31, Dan King [EMAIL PROTECTED]: Hi there, I am attempting to install DBD-Oracle using ppm 4.0 on a Windows XP computer that has ActiveState version 5.8.8 installed. In the command line I have type ppm install DBD-Oracle ppm install DBD::Oracle None of these work and results

ppm install failed for DBD-Oracle because it can't find the package

2008-01-31 Thread Dan King
Hi there, I am attempting to install DBD-Oracle using ppm 4.0 on a Windows XP computer that has ActiveState version 5.8.8 installed. In the command line I have type ppm install DBD-Oracle ppm install DBD::Oracle None of these work and results in the error below: ppm install

RE: ppm install failed for DBD-Oracle because it can't find the package

2008-01-31 Thread Dan King
failed for DBD-Oracle because it can't find the package 2008/1/31, Dan King [EMAIL PROTECTED]: Hi there, I am attempting to install DBD-Oracle using ppm 4.0 on a Windows XP computer that has ActiveState version 5.8.8 installed. In the command line I have type ppm install DBD-Oracle ppm

Re: DBI-DBD::ORACLE EROR

2008-01-30 Thread Peter J. Holzer
On 2008-01-29 19:14:51 -0800, Jonathan Leffler wrote: On Jan 29, 2008 5:31 AM, Mohammed, Shafi [EMAIL PROTECTED] wrote: I need following files. As has already been explained to you -- you need to get those files from a legitimate source, namely Oracle, or your authorized Oracle

DBI-DBD::ORACLE EROR

2008-01-29 Thread Mohammed, Shafi
Hello , Now I want to use DBI for my current project. Here I have trying to install DBD::ORACLE PACKAGE it is thronging error. And it is now allowing to install this package. Please help us in installing this package. Please tell me what are the steps to be taken care while

Re: DBI-DBD::ORACLE EROR

2008-01-29 Thread John Scoles
To: John Scoles Cc: Mohammed, Shafi; dbi-users@perl.org Subject: Re: DBI-DBD::ORACLE EROR Hello! On Tue, 29 Jan 2008, John Scoles wrote: It would be nice to see the output for the Makefile.PL as well Looks like either one of few things 1) you do not have the full oracle 9

Re: DBI-DBD::ORACLE EROR

2008-01-29 Thread Alexander V Alekseev
Hello! On Tue, 29 Jan 2008, John Scoles wrote: It would be nice to see the output for the Makefile.PL as well Looks like either one of few things 1) you do not have the full oracle 9 client installed 2) you do not have the ORACLE_HOME= or LD_LIBRARY_PATH set correctly

Re: DBI-DBD::ORACLE EROR

2008-01-29 Thread John Scoles
at the README.linux.txt and try some of the suggestions there as well cheers John Scoles Mohammed, Shafi wrote: Hello , Now I want to use DBI for my current project. Here I have trying to install DBD::ORACLE PACKAGE it is thronging error. And it is now allowing to install this package

RE: DBI-DBD::ORACLE EROR

2008-01-29 Thread Mohammed, Shafi
[mailto:[EMAIL PROTECTED] Sent: Tuesday, January 29, 2008 6:56 PM To: John Scoles Cc: Mohammed, Shafi; dbi-users@perl.org Subject: Re: DBI-DBD::ORACLE EROR Hello! On Tue, 29 Jan 2008, John Scoles wrote: It would be nice to see the output for the Makefile.PL as well Looks

Re: DBI-DBD::ORACLE EROR

2008-01-29 Thread Jonathan Leffler
On Jan 29, 2008 5:31 AM, Mohammed, Shafi [EMAIL PROTECTED] wrote: I need following files. As has already been explained to you -- you need to get those files from a legitimate source, namely Oracle, or your authorized Oracle supplier. Nothing else will work; no-one who respects the law will

Re: SSL connection with DBD::Oracle?

2008-01-25 Thread Alexander Foken
network, that only supports ssl connections. Is there a way to do this using DBD::Oracle? Is there some other way to do this? Any assistance appreciated. Tim Hester -- Alexander Foken mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/

SSL connection with DBD::Oracle?

2008-01-25 Thread Tim Hester
I need to connect to an Oracle db on a remote machine, on the local network, that only supports ssl connections. Is there a way to do this using DBD::Oracle? Is there some other way to do this? Any assistance appreciated. Tim Hester

FW: help to install DBD-Oracle-1.18

2008-01-21 Thread Capacio, Paula J
On Saturday, January 19, 2008 2:54 PM gokul nath [mailto:[EMAIL PROTECTED] wrote: To: Capacio, Paula J hello sir i need u r help. i have installed perl 5.8.8 in my windows box. oracle 10g XE DBI 1.5 i tried to install DBD-Oracle-1.18 , when i execute nmake file , following error

ANNOUNCE: DBD::Oracle 1.20 Release Candidate 8

2008-01-07 Thread John Scoles
In an effort to broaden the testing base I would like as many of you out there to give a try at installing and running http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.20-RC8.tar.gz So far we think we have most of the problems ironed out but we still need a larger test pool

installing DBD-Oracle-1.19

2008-01-04 Thread Andrew_Wiatr
Hi, I have installed this version without any problem where I have a full Oracle installation but have a problem installing where only the instant client is installed. Cheers Andrew [EMAIL PROTECTED] DBD-Oracle-1.19]# perl Makefile.PL Multiple copies of Driver.xst found in: /usr/lib/perl5

RE: Can't locate DBD/Oracle.pm after DBD Oracle 1.19 installation

2007-12-27 Thread Capacio, Paula J
-Original Message- From: Susantio, Herman [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 25, 2007 9:03 PM To: 'dbi-users@perl.org' Subject: Can't locate DBD/Oracle.pm after DBD Oracle 1.19 installation we just installed DBD Oracle 1.19 on Linux suse. oracle 10.1.0.3 full version has

Can't locate DBD/Oracle.pm after DBD Oracle 1.19 installation

2007-12-26 Thread Susantio, Herman
Hi all, we just installed DBD Oracle 1.19 on Linux suse. oracle 10.1.0.3 full version has been installed on the same box prior installing DBD and the db instance is accessible. after the DBD Oracle installation, when we run the perl script, we hit the following error : ./test.pl

heap corruption in DBD::Oracle

2007-12-16 Thread Peter J. Holzer
anybody run into this problem before or do I need to dig deeper? Version information: DBD::Oracle 1.19 DBI 1.58 perl v5.8.8 built for x86_64-linux-thread-multi Red Hat Enterprise Linux AS release 4 (Nahant Update 5) Oracle 10.2.0.1.0 hp -- _ | Peter J. Holzer

Re: heap corruption in DBD::Oracle

2007-12-16 Thread Peter J. Holzer
On 2007-12-16 23:07:36 +0100, Peter J. Holzer wrote: I have a perl script which updates some (large) tables from text-files, inserting, updating and deleting records. For performance reasons the inserts, updates and deletes are queued together and then done with an array operation when there

DBD::Oracle 1.20 Release Candidate 4 Report on HP-UX 11i

2007-12-11 Thread Richard T Malafa
://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.20-RC4.tar.gz Richard T Malafa wrote: John Do I Change the RC2 in the URL to RC3 to get this new release? Thank You Rich • '•..• '•. º .• '•. .• '•. •. .• '•. º “Anything that doesn’t eat you today is saving you for tomorrow

Anyone: Status DBD::Oracle 1.19

2007-11-29 Thread Richard T Malafa
Has anyone successfully finished installing a successful DBD::Oracle 1.19 on a HP UX 11i machine against Oracle 10g??? This is using Perl 5.8.8 done with open source gcc. And it has DBI 1.50 built in. We have gotten to the make test part and and can't seem to get it to run.. The Perl

collections in DBD::Oracle

2007-11-20 Thread Dautkhanov
Hello, As I see last activity in SVN at dbd-oracle/branches, all that patches will bring DBD::Oracle possibility to work with collections. When it planned to be release? Thanks Ruslan

Re: DBD::Oracle and Perl's internal representation of strings

2007-11-09 Thread Charles Jardine
On 07/11/07 17:38, E R wrote: Hi, I just posted this question on Perl Monks: http://perlmonks.com/?node_id=649489 Am I correct in my analysis of what's going? You might be interested in a thread which I started just over two years ago. See

Segmentation fault with module DBD::Oracle 1.19 on SuSE Linux Enterprise Server 10 (IBM Power 64 bit)

2007-11-09 Thread Roberto Zini
Hello everybody. I'm trying to get the DBD::Oracle 1.19 Perl module working fine under SuSE Linux Enterprise Server 10 (IBM Power 64bit). The version of SLES is 10.0 (no SP1 applied yet) and the version of Perl I'm using is: === cut here == 8 == Summary of my perl5 (revision 5 version 8

Re: Segmentation fault with module DBD::Oracle 1.19 on SuSE Linux Enterprise Server 10 (IBM Power 64 bit)

2007-11-09 Thread scoles
I think you have to install the perl-devel package Hello everybody. I'm trying to get the DBD::Oracle 1.19 Perl module working fine under SuSE Linux Enterprise Server 10 (IBM Power 64bit). The version of SLES is 10.0 (no SP1 applied yet) and the version of Perl I'm using is: === cut

Re: Segmentation fault with module DBD::Oracle 1.19 on SuSE Linux Enterprise Server 10 (IBM Power 64 bit)

2007-11-09 Thread Peter J. Holzer
On 2007-11-09 15:12:03 +0100, Roberto Zini wrote: Hello everybody. I'm trying to get the DBD::Oracle 1.19 Perl module working fine under SuSE Linux Enterprise Server 10 (IBM Power 64bit). I don't know about the Power architecture specifically, but on most platforms you cannot link 64 and 32

Re: Segmentation fault with module DBD::Oracle 1.19 on SuSE Linux Enterprise Server 10 (IBM Power 64 bit)

2007-11-09 Thread Roberto Zini
Roberto Zini wrote: [EMAIL PROTECTED] wrote: I think you have to install the perl-devel package OK. Thanks for the input. I'll download the SDK package (which holds the perl-devel) and let you. Thanks, Roberto Uhm... not sure about that. I just tried to get it to work with SuSE

Re: DBD::Oracle and Perl's internal representation of strings

2007-11-09 Thread E R
over two years ago. See http://www.nntp.perl.org/group/perl.dbi.users/2005/08/msg27335.html This is exactly the issue I am trying to raise. The only solution seems to be to explicitly encode all the strings in the encoding you want before passing them to DBD::Oracle. For example, instead

Re: DBD::Oracle and Perl's internal representation of strings

2007-11-08 Thread Martin Evans
of the first row of the query. The above code emits: result: However, if I change NLS_LANG to AMERICAN_AMERICA.US7ASCII, it emits: result: 1 Is there another NLS_LANG setting I should use, or should I check my versions of OCI, DBD::Oracle and perl? I think I'm running OCI version 8. My perl is 5.8.0

Re: DBD::Oracle and Perl's internal representation of strings

2007-11-08 Thread E R
via package DBI::db at ./t10 line 30. Do I need to upgrade my OCI, or DBI or DBD::Oracle? As for the attached test script, here's some output: $ ./t8.new --home /product01/oracle/9iAS/9.0.4b/ -nls 0 ORACLE_HOME = /product01/oracle/9iAS/9.0.4b/ NLS_LANG= ORA_NLS = ORA_OCI() = 8 test 0

<    4   5   6   7   8   9   10   11   12   13   >