Re: centos perl-DBD:Oracle

2010-04-29 Thread Michael Ludwig
Am 29.04.2010 um 04:08 schrieb Pam Wampler: What are the steps to install perl-DBD:Oracle on a centos 5 server? rpm -i perl-DBD-Oracle-1.19-1.el5.i386.rpm warning: perl-DBD-Oracle-1.19-1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e42d547b error: Failed dependencies:

RE: (Fwd) Problems inserting into a CLOB field type using DBI PERL

2010-04-29 Thread Arshad Mahmood
Hi, Many thanks for your assistance. Thank you for highlighting that John. I have managed to fix the problem, I also needed to set the LongReadLen and LongTruncOk attributes which control how long columns are retrieved. I appreciate your support Wishing you all the best Ash -Original

Re: centos perl-DBD:Oracle

2010-04-29 Thread Kim
Hi Pam, Pam Wampler wrote: What are the steps to install perl-DBD:Oracle on a centos 5 server? I have the following oracle rpm's installed rpm -qa | grep oracle oracle-instantclient11.2-odbc-11.2.0.1.0-1 oracle-instantclient-sqlplus-10.2.0.3-1 oracle-instantclient-basic-10.2.0.3-1

unable to install DBI for Perl version 5.8.0 from windows X86

2010-04-29 Thread ranjith makineni
Hi, I need to install DBI for connection to Oracle Database for Perl version 5.8.0 from windows X86. I have downloaded DBI-1.48. We are able to run perl Makefile.PL, but unable to nmake or dmake commands on windows. we are getting the error 'nmake' is not recognized as an internal or external

Re: unable to install DBI for Perl version 5.8.0 from windows X86

2010-04-29 Thread Michael Ludwig
Am 28.04.2010 um 18:01 schrieb ranjith makineni: I need to install DBI for connection to Oracle Database for Perl version 5.8.0 from windows X86. Perl 5.8.0 is ages old. You should upgrade to get the bugfixes. I have downloaded DBI-1.48. We are able to run perl Makefile.PL, but unable to

Re: DBI/DBD question

2010-04-29 Thread Royce Miller
I am working with the Informix DBA.  The original DBA also got laid off so he didn't install.  But he is comparing this environment with the other environment that is working.  He is also going to create a stores database so I can rebuild DBD on the newer system.  Meanwhile, I have confirmed

Re: how to post

2010-04-29 Thread Jeff Zucker
On Wed, Apr 28, 2010 at 7:11 PM, Pam Wampler pwamp...@acttoday.com wrote: How do I post a question to this forum? Not unlike the way you posted that one :-). -- Jeff Thanks, Pam Wampler Senior Oracle Database Administrator Advanced Call Center Technologies, LLC. 3035 Boones

Re: unable to install DBI for Perl version 5.8.0 from windows X86

2010-04-29 Thread John Scoles
ranjith makineni wrote: For DBD::Oracle and DBI you will need to get a copy of a Visual C++ compiler and nmake. If you down load DBD::ORacle 1.24 and have a look at the README.win32 it has full instructions on what you have to do. You are better off using a later version of DBI than the

question on how a path/directory is picked up

2010-04-29 Thread Pam Wampler
I am still battling this problem install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/ Oracle.so' for module DBD::Oracle: /usr/lib/oracle/11.2/client/lib/libocci.so.11.1: cannot restore segment prot after reloc: Permission denied at

Having a problem conneting to an Oracle 11gr2 RAC

2010-04-29 Thread Stricker, Scott (IS)
Don't know if anyone has worked with the Oracle RAC environment and perl. Using sqlplus, I can do the following C:\sqlplus ais_dbo/passw...@edc-dbserver/HCSMDA SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 29 11:55:35 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved.

Announce: DBI 1.611

2010-04-29 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.611.tar.gz size: 534200 bytes md5: f48bc718e871f8926809af16682783fb =head2 Changes in DBI 1.611 (svn r13935) 29th April 2010 NOTE: minimum perl version is now 5.8.1 (as announced in DBI 1.607) Fixed selectcol_arrayref MaxRows attribute to count

RE: question on how a path/directory is picked up

2010-04-29 Thread John Scoles
Looks like you are trying to 'run' a DBD::Oracle that was compiled against the 11.2 client against the 10.2 client?? Or the path to the 11.2 client is somehere in you enviornment perhaps the PATH or the client .so files have permission setting that do not allow you to execute them

RE: Having a problem conneting to an Oracle 11gr2 RAC

2010-04-29 Thread John Scoles
It is somthing in you connection string or you do not have the TNS_ADMIN env car set TNS_ADMIN should point to your TNSNAMES.ORA file Subject: Having a problem conneting to an Oracle 11gr2 RAC Date: Thu, 29 Apr 2010 15:03:18 -0500 From: scott.stric...@ngc.com To: