RE: DBD::Oracle, 10g Lob Refetch problem

2010-12-21 Thread Furst, Carl
10 11:13 AM To: dbi-users@perl.org Subject: Re: DBD::Oracle, 10g Lob Refetch problem On 21/12/2010 10:48 AM, Furst, Carl wrote: > Thanks to all of you for taking the time to answer my questions. > Unfortunately I don't have the output from the compile. However consider > that we are able

Re: DBD::Oracle, 10g Lob Refetch problem

2010-12-21 Thread John Scoles
obs, so it has me worried. I'll keep y'all posted. Thanks, Carl Furst CMS Developer MLB Advanced Media -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Tuesday, December 21, 2010 8:51 AM To: dbi-users@perl.org Subject: Re: DBD::Oracle, 10g Lob Refetch problem

RE: DBD::Oracle, 10g Lob Refetch problem

2010-12-21 Thread Furst, Carl
MLB Advanced Media -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Tuesday, December 21, 2010 8:51 AM To: dbi-users@perl.org Subject: Re: DBD::Oracle, 10g Lob Refetch problem On 20/12/2010 3:17 PM, Furst, Carl wrote: > Hello, > > I just built DBD

Re: DBD::Oracle, 10g Lob Refetch problem

2010-12-21 Thread John Scoles
On 20/12/2010 3:17 PM, Furst, Carl wrote: Hello, I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 32 bit against client 10.0.2.4 We've been having trouble since day one. The biggest problem is that we are having a problem writing LOB fields. We get the following error:

Re: DBD::Oracle, 10g Lob Refetch problem

2010-12-21 Thread Martin J. Evans
On 21/12/10 09:18, Michael Ludwig wrote: > Martin J. Evans schrieb am 21.12.2010 um 09:03 (+): > >> e.g. for my database here with a SID of "devel" where the database is >> running on betoracle.easysoft.local and my user is fred/password I do: >> >> export ORACLE_USERID=fred/password > > Mino

Re: DBD::Oracle, 10g Lob Refetch problem

2010-12-21 Thread Michael Ludwig
Martin J. Evans schrieb am 21.12.2010 um 09:03 (+): > e.g. for my database here with a SID of "devel" where the database is > running on betoracle.easysoft.local and my user is fred/password I do: > > export ORACLE_USERID=fred/password Minor correction for TWO_TASK: > export TWO_TASK=//beto

Re: DBD::Oracle, 10g Lob Refetch problem

2010-12-21 Thread Martin J. Evans
On 20/12/10 20:17, Furst, Carl wrote: > Hello, > > I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 32 bit > against client 10.0.2.4 Did you run make test when you installed DBD::Oracle with valid login and if so what was the output? > We've been having trouble since day

RE: DBD::Oracle, 10g Lob Refetch problem

2010-12-20 Thread Furst, Carl
rs@perl.org Subject: Re: DBD::Oracle, 10g Lob Refetch problem Moin Carl, Furst, Carl schrieb am 20.12.2010 um 15:17 (-0500): > > I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 > 32 bit against client 10.0.2.4 Perl 5.8.5 is from mid-2004, so six and a half years old. Time

Re: DBD::Oracle, 10g Lob Refetch problem

2010-12-20 Thread Michael Ludwig
Moin Carl, Furst, Carl schrieb am 20.12.2010 um 15:17 (-0500): > > I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 > 32 bit against client 10.0.2.4 Perl 5.8.5 is from mid-2004, so six and a half years old. Time to upgrade to 5.8.9. (And then on to 5.10.1, and 5.12.2, if you

DBD::Oracle, 10g Lob Refetch problem

2010-12-20 Thread Furst, Carl
Hello, I just built DBD::Oracle 1.26 on Solaris SPARC 2.10 using perl 5.8.5 32 bit against client 10.0.2.4 We've been having trouble since day one. The biggest problem is that we are having a problem writing LOB fields. We get the following error: DBD::Oracle::st execute failed: ORA-0

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-08 Thread Eric Yellin
On 05/10/2010 17:44, Scott T. Hildreth wrote: On Sun, 2010-10-03 at 18:45 +0200, Eric Yellin wrote: Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Eric, Are you compiling a linux Perl? It won't work with out it. I have the port emul

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-05 Thread Scott T. Hildreth
On Sun, 2010-10-03 at 18:45 +0200, Eric Yellin wrote: > > Hi, > > > I am trying to compile DBD::Oracle that will work with Oracle 10g on > FreeBSD 6.3 > > Eric, Are you compiling a linux Perl? It won't work with out it. I have the port emulators/linux

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-05 Thread John Scoles
On 10/5/2010 3:58 AM, Martin J. Evans wrote: On 03/10/10 17:45, Eric Yellin wrote: Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Here is what I have done so far: 1. Installed the 3 Oracle Instant Client ports: - linux-oracle-instantclient-basic

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-05 Thread Martin J. Evans
On 03/10/10 17:45, Eric Yellin wrote: > > > Hi, > > > I am trying to compile DBD::Oracle that will work with Oracle 10g on > FreeBSD 6.3 > > > Here is what I have done so far: > > 1. Installed the 3 Oracle Instant Client ports: > > - linux-o

Re: Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-04 Thread John Scoles
On 10/3/2010 12:45 PM, Eric Yellin wrote: I have yet to try an build DBD::Oracle for FreeBSD so the Makefile might not be working correctly here are my comments Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Here is what I have done so far: 1

Problem compiling DBD::Oracle on FreeBSD with Oracle 10g Instant Client

2010-10-03 Thread Eric Yellin
Hi, I am trying to compile DBD::Oracle that will work with Oracle 10g on FreeBSD 6.3 Here is what I have done so far: 1. Installed the 3 Oracle Instant Client ports: - linux-oracle-instantclient-basic - linux-oracle-instantclient-sdk - linux-oracle-instantclient-sqlplus These install

Re: Oracle::DBI module - Issues in connecting to Oracle 10G

2009-01-12 Thread Mike Nhan
hoststring.10G = (DESCRIPTION= (LOAD_BALANCE=yes) (ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.123)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.124)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=) ) ) Currently, using the DBI module I am able to connect to these servers (x.x.

RE: Oracle::DBI module - Issues in connecting to Oracle 10G

2009-01-09 Thread Martin Gainty
party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Fri, 9 Jan 2009 14:31:28 -0800 > From: write2sr...@yahoo.com > Subject: Oracle::DBI module - Issues in connecting to Oracle 10G > To: dbi-users@perl.or

Oracle::DBI module - Issues in connecting to Oracle 10G

2009-01-09 Thread Srinu
Hello, Can someone help with me a DBI issue I'm having in connecting to an Oracle 10g DB server? We have production scripts that loads data into DB (oracle9i) using DBI module. We recently migrated our database to oracle 10g. Our DBA has implemented load balancing on this 10g server and

DBD::Oracle 1.22 not compiling on AIX 5.3, Oracle 10g client

2008-08-20 Thread Naqvi Zahid - znaqvi
root @ server > make cp Oracle.pm blib/lib/DBD/Oracle.pm cp oraperl.ph blib/lib/oraperl.ph cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h cp Oraperl.pm blib/lib/Oraperl.pm cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h cp lib/DBD/Oracle/GetI

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

2008-06-20 Thread Peter J. Holzer
On 2008-04-22 12:59:26 -0700, Dunston Rocks wrote: > I had posted a few days ago about facing problems installing DBD::Oracle with > Oracle 10g client under Cygwin. Regular client or instant client? > Though those were circumvented successfully, when I try to run a simple > scrip

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 gro

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}

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

2008-04-30 Thread Christian Merz
reciate your help in identifying the problem, if possible!!! Thanks much! - Original Message From: Christian Merz <[EMAIL PROTECTED]> To: Dunston Rocks <[EMAIL PROTECTED]> Cc: dbi-users@perl.org Sent: Thursday, April 24, 2008 3:38:12 AM Subject: Re: OCIEnvNlsCreate error with

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

2008-04-25 Thread Dunston Rocks
ORACLE_HOME env var, NLS settings, permissions, etc. at tmp.pl line 26. I would greatly appreciate your help in identifying the problem, if possible!!! Thanks much! ----- Original Message From: Christian Merz <[EMAIL PROTECTED]> To: Dunston Rocks <[EMAIL PROTECTED]> Cc: db

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

2008-04-24 Thread Dunston Rocks
ror with DBD::Oracle 1.21 and Oracle 10g client in Cygwin Hello Dunston, in my test script i set: $ENV{ORACLE_SID}= "ORCL"; $ENV{ORACLE_HOME} = "/path/to/oracle/home"; $ENV{NLS_LANG} = "AMERICAN_AMERICA.WE8DEC"; # or &q

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

2008-04-24 Thread Christian Merz
08 6:50:57 AM Subject: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin Hello Dunston, in my test script i set: $ENV{ORACLE_SID}= "ORCL"; $ENV{ORACLE_HOME} = "/path/to/oracle/home"; $ENV{NLS_LANG} = "AMERICAN_AMER

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

2008-04-23 Thread Christian Merz
27;/oracle/product/10.2.0/nls/data'; cu, Christian Dunston 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->Conn

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

Re: ORA-1008 on Oracle 10g (update)

2008-04-04 Thread [EMAIL PROTECTED]
17:47 An: dbi-users@perl.org Betreff: ORA-1008 on Oracle 10g Hello! i am writing a script querying a Oracle database with prepared statements. The database owner has upgradeed the database from version 9.2 to version 10g. Since this "upgrade" the scripts

Re: ORA-1008 on Oracle 10g

2008-04-03 Thread [EMAIL PROTECTED]
69 50065 515 Mobil: +49 172 6648 604 Von: [EMAIL PROTECTED] Gesendet: Donnerstag, 14. Februar 2008 17:47 An: dbi-users@perl.org Betreff: ORA-1008 on Oracle 10g Hello! i am writing a script querying a Oracle database with prepared statements. The database o

ORA-1008 on Oracle 10g

2008-02-15 Thread Olaf.Ohlenmacher
devel/Programme/DBhandling.pm line 459 There are only two parameters :p1 and :p2 with both have valid values. Have you any suggestion why this statement failed on Oracle 10g? Do you know about any problems with the module version i am using (see below)? Using this version... ActiveSta

Re: (Fwd) Re: DBD::Oracle won't install for Oracle 10G XE

2007-08-22 Thread jim
, Tim Bunce wrote: - Forwarded message from [EMAIL PROTECTED] - X-IP: 216.150.208.7 From: [EMAIL PROTECTED] To: Tim Bunce <[EMAIL PROTECTED]> Subject: Re: DBD::Oracle won't install for Oracle 10G XE Date: Mon, 13 Aug 2007 22:42:59 -0700 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i

Re: (Fwd) Re: DBD::Oracle won't install for Oracle 10G XE

2007-08-22 Thread Peter J. Holzer
On 2007-08-21 22:01:02 -0600, jim wrote: > The following URL's did the trick on my SuSE 10.2. > Although the white paper was for the 32 bit version the screens were nearly > identical for the 64 bit installer. > Hope this helps anyone out there with similar problems. > http://www.oracle.com/techno

Re: (Fwd) Re: DBD::Oracle won't install for Oracle 10G XE

2007-08-17 Thread Peter J. Holzer
On 2007-08-14 09:53:33 +0100, Tim Bunce wrote: > - Forwarded message from [EMAIL PROTECTED] - > > X-IP: 216.150.208.7 > From: [EMAIL PROTECTED] > To: Tim Bunce <[EMAIL PROTECTED]> > Subject: Re: DBD::Oracle won't install for Oracle 10G XE > Date: Mon, 13

(Fwd) Re: DBD::Oracle won't install for Oracle 10G XE

2007-08-14 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - X-IP: 216.150.208.7 From: [EMAIL PROTECTED] To: Tim Bunce <[EMAIL PROTECTED]> Subject: Re: DBD::Oracle won't install for Oracle 10G XE Date: Mon, 13 Aug 2007 22:42:59 -0700 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686 (x86_64);

[Fwd: RE: :Oracle on Solaris 9/10 and Oracle 10g]

2007-07-23 Thread Jim Brandt
- From: Jim Brandt [mailto:[EMAIL PROTECTED] Sent: July 20, 2007 2:01 PM To: dbi-users@perl.org Subject: DBD::Oracle on Solaris 9/10 and Oracle 10g I found some discussion with the above subject from around February 2007 and thought I'd add my experience, since I just had to compile DBD::Ora

DBD::Oracle on Solaris 9/10 and Oracle 10g

2007-07-20 Thread Jim Brandt
I found some discussion with the above subject from around February 2007 and thought I'd add my experience, since I just had to compile DBD::Oracle on one of our Solaris systems. I found that to get the compile to properly point at the 32-bit libraries, I had to make the following changes to

Re: DBI - DBD with Oracle 10g on Windows XP

2007-05-10 Thread John Scoles
it will work with 5.8 too)- works perfect. After that over ppm upgrade to the latest DBI. After that - http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.19/ - take a look in README.win32.txt document. I have made it yesterday on Win2000 using Visual C++ Express Edition and Oracle 10g instant client

FW: DBI - DBD with Oracle 10g on Windows XP

2007-05-10 Thread Tzekov, Ianko
Win2000 using Visual C++ Express Edition and Oracle 10g instant client (after the second attempt :-) and it works. I see no reason why this will not work for WinXP. Regards, Ianko -Original Message- From: Galo Balda [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 6:25 PM To: dbi

DBI - DBD with Oracle 10g on Windows XP

2007-05-10 Thread Galo Balda
Hi list, Anybody has a document / link explanining how to setup DBI and DBD::Oracle with Oracle 10g on Windows XP? Regards Xavier

RE: Oracle 10G and perl v5.8.0

2007-02-15 Thread Reidy, Ron
DBA Array BioPharma, Inc. -Original Message- From: Krishnan, Vijaya [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 12:29 PM To: dbi-users@perl.org Cc: Lootens, Robin Subject: Oracle 10G and perl v5.8.0 Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an

Re: Oracle 10G and perl v5.8.0

2007-02-15 Thread Kevin Spencer
On 2/14/07, Krishnan, Vijaya <[EMAIL PROTECTED]> wrote: Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an upgrade to perl 6 would be required. Perl 6 has not been released yet ;-) FWIW, I'm using 10G with 5.8.8 and everything plays nicely together. -- Kevin.

RE: Oracle 10G and perl v5.8.0

2007-02-15 Thread Garrett, Philip \(MAN-Corporate\)
Krishnan, Vijaya wrote: > Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an > upgrade to perl 6 would be required. They're compatible. I'd recommend using the latest stable version of Perl, though -- 5.8.8. (Perl 6 is not released yet...) Philip

Oracle 10G and perl v5.8.0

2007-02-15 Thread Krishnan, Vijaya
Just wanted to know if Oracle 10G and perl v5.8.0 are compatible or an upgrade to perl 6 would be required. Thanks, Vijaya Vijaya Krishnan Commercial / Government Card Technology and Payment Services Treasury and Payments Services (TPS) Technology Ph:704-683-0881(W);704-841-4358(H) Pager

RE: :Oracle on Solaris 10 and Oracle 10g

2007-02-08 Thread Reidy, Ron
-users@perl.org Cc: Jay Tipton Subject: DBD::Oracle on Solaris 10 and Oracle 10g I am trying to get DBD::Oracle installed on a Solaris 10 system (64bit) with Oracle 10g. I downloaded DBD-Oracle-1.19. As root, I run perl Makefile.PL , which seems to run successfully, but when I run make test, I get

RE: :Oracle on Solaris 10 and Oracle 10g

2007-02-08 Thread Matthew Ramadanovic
[mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 5:35 PM To: dbi-users@perl.org Cc: Jay Tipton Subject: DBD::Oracle on Solaris 10 and Oracle 10g I am trying to get DBD::Oracle installed on a Solaris 10 system (64bit) with Oracle 10g. I downloaded DBD-Oracle-1.19. As root, I run perl Mak

DBD::Oracle on Solaris 10 and Oracle 10g

2007-02-08 Thread Jay Tipton
I am trying to get DBD::Oracle installed on a Solaris 10 system (64bit) with Oracle 10g. I downloaded DBD-Oracle-1.19. As root, I run perl Makefile.PL , which seems to run successfully, but when I run make test, I get: ld:fatal: file Oracle.o : wrong ELF class: ELFCLASS32 I can see no

RE: Problems using an old version of DBI to connect to a remote Oracle 10g database

2007-01-08 Thread Reidy, Ron
08, 2007 9:04 AM To: dbi-users@perl.org Subject: Problems using an old version of DBI to connect to a remote Oracle 10g database Dear all, Appreciate if someone can help me with this. I have a Solaris 5.6 Generic_105181-33 box on which I have Perl version 5.005_03. I also have Perl modules DBI

Re: Problems using an old version of DBI to connect to a remote Oracle 10g database

2007-01-08 Thread John Scoles
I would say yes as DBD::Oracel 1.06 is about 13 revisoins out of date. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, January 08, 2007 11:04 AM Subject: Problems using an old version of DBI to connect to a remote Oracle 10g database Dear all, Appreci

Problems using an old version of DBI to connect to a remote Oracle 10g database

2007-01-08 Thread dave.salisbury
remote Oracle 10g instance: my $dbh = DBI->connect ("dbi:Oracle:$environment",$nsm_login,$nsm_password) || die "Unable to connect to $environment: $DBI::errstr\n"; ...where $environment is the instance name - this is defined in tnsnames.ora. I am getting the following er

Re: Oracle 10G Connectivity with DBI and DBD in UNIX

2006-08-28 Thread John Scoles
DBD >>modules for connecting the application to Oracle . >>Current Configuration of DBI and DBD: >>DBI v1.28 >>DBD-Oracle v1.15 >>Now I need to migrate my application to Oracle 10G. >>I would like to know, whether is it necessary to install the latest DBD >>(

Oracle 10G Connectivity with DBI and DBD in UNIX

2006-08-25 Thread Rajamanickam, Venkatesh
Hi, In my application, I am using perl version 5.6.1. I am currently using Oracle 9i database and I am using DBI and DBD modules for connecting the application to Oracle . Current Configuration of DBI and DBD: DBI v1.28 DBD-Oracle v1.15 Now I need to migrate my application to Oracle 10G. I

RE: DBI/DBD::Oracle and Oracle 10g

2006-05-26 Thread Garrett, Philip \(MAN-Corporate\)
From: Dan Werner [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 4:36 PM To: 'dbi-users@perl.org' Subject: DBI/DBD::Oracle and Oracle 10g > > Should it be necessary to recompile DBI and/or DBD::Oracle when > upgrading from Oracle 9.2.0.4.0 to 10.2.0.2.0? If only the

RE: DBI/DBD::Oracle and Oracle 10g

2006-05-25 Thread Dan Werner
Might be useful to mention that we use DBI version 1.37 and DBD::Oracle version 1.14. _ From: Dan Werner [mailto:[EMAIL PROTECTED] Sent: Thursday, May 25, 2006 4:36 PM To: 'dbi-users@perl.org' Subject: DBI/DBD::Oracle and Oracle 10g Should it be necessary to recompile DBI

DBI/DBD::Oracle and Oracle 10g

2006-05-25 Thread Dan Werner
Should it be necessary to recompile DBI and/or DBD::Oracle when upgrading from Oracle 9.2.0.4.0 to 10.2.0.2.0? Our DBA's recently did this upgrade, and since then, I've been unable to get DBI working 100%. The lingering problem is that I cannot select character fields. If I do "select varchar2_

Re: Workaround needed. Re: Re: perl DBI 1.25 not connectting to Oracle 10g

2006-01-09 Thread Peter J. Holzer
On 2006-01-05 23:48:48 -, Sunil A V wrote: > LD_RUN_PATH="/opt/oracle/product/10.2.0.1.0_64/lib32:/opt/oracle/product/10.2.0.1.0_64/rdbms/lib32" > cc -G Oracle.o dbdimp.o oci8.o > -L/opt/oracle/product/10.2.0.1.0_64/lib/ > -L/opt/oracle/product/10.2.

RE: Workaround needed. Re: Re: perl DBI 1.25 not connectting to Oracle 10g

2006-01-06 Thread Andy Hassall
bit Oracle libraries with 32-bit Perl. So you need either: (1) 32-bit Oracle libraries, which tend to be in a "lib32" directory instead of "lib" in the Oracle home. But if I remember correctly, 32-bit Solaris support was removed from Oracle 10g. So you could use a previous versio

Workaround needed. Re: Re: perl DBI 1.25 not connectting to Oracle 10g

2006-01-05 Thread Sunil A V
V wrote > > > > Hi, > > > > I am trying this combination: > > perl: v5.61 > > DBI: 1.25 > > Oracle: 10g > > OS: Solaris Unix > > The directory /home/me/perlmods contains DBI.pm, DBI dir, DBD dir, > > Bundle, etc > > > > In my perl prog

Re: Re: perl DBI 1.25 not connectting to Oracle 10g

2006-01-05 Thread Sunil A V
>On 5 Jan 2006 19:01:35 -, Sunil A V wrote > > > > Hi, > > > > I am trying this combination: > > perl: v5.61 > > DBI: 1.25 > > Oracle: 10g > > OS: Solaris Unix > > The directory /home/me/perlmods contains DBI.pm, DBI dir, DBD dir, > &

Re: perl DBI 1.25 not connectting to Oracle 10g

2006-01-05 Thread Matthew Dougerty
You need Oracle DBD. If it's there there will be per5~/DBD/Oracle.pm and an Oracle directory. On 5 Jan 2006 19:01:35 -, Sunil A V wrote >   > Hi, > > I am trying this combination: > perl: v5.61 > DBI: 1.25 > Oracle: 10g > OS: Solaris Unix > The directory /

perl DBI 1.25 not connectting to Oracle 10g

2006-01-05 Thread Sunil A V
  Hi, I am trying this combination: perl: v5.61 DBI: 1.25 Oracle: 10g OS: Solaris Unix The directory /home/me/perlmods contains DBI.pm, DBI dir, DBD dir, Bundle, etc In my perl program I am using BEGIN {unshift(@INC,'/home/me/perlmods')} use DBI; my $dbh = DBI->connect('DBI:O

RE: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

2005-12-19 Thread Reidy, Ron
Then it is permissions. -Original Message- From: DBA FARMASA [mailto:[EMAIL PROTECTED] Sent: Monday, December 19, 2005 9:46 AM To: dbi-users@perl.org Subject: RES: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?) >> -Original Message- >> From:

RES: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

2005-12-19 Thread DBA FARMASA
>> -Original Message- >> From: DBA FARMASA [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, December 14, 2005 11:47 AM >> To: dbi-users@perl.org >> Subject: Oracle 10g + Linux RHEL 4 + Perl + DBI = >> OCIEnvNlsCreate Error >> (!?!?) >> >

RE: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

2005-12-14 Thread Reidy, Ron
owner of the Apache software? Check permissions of $ORACLE_HOME/bin and $ORACLE_HOME/lib -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: DBA FARMASA [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 14, 2005 11:47 AM To: dbi-users@perl.org Subject: Oracle 10g

Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

2005-12-14 Thread DBA FARMASA
Hi fellows. I'm banging my head on this problem for a month, and posted on London PM without a good clue. Maybe you folks can help me a little bit more. I need to connect Best Pratical's RT 3.4.4 to an Oracle 10g Database running on the same box. I'm using the mod_perl

re: Oracle 10g and DBD::Oracle

2005-12-13 Thread Jared Still
It appears that you are seeing the parse done by DBD::Oracle to describe the table. Look at the DBI docs for ora_check_sql. Turn it off and the extra parse should go away. Jared On Thu, 2005-12-08 at 11:00 -0500, Peter Santos wrote: > Dear users, > I'm hoping to get some insight into why oracle

Re: Oracle 10g and DBD::Oracle

2005-12-09 Thread Peter Santos
set the bind variables to a new value. This gives me 1 hard parse and 2 soft parses and ONLY 1 cursor in the database (V$SQL). HTH --peter Reidy, Ron wrote: This does not look the same. Where are the bind variables? -Original Message- From: Peter Santos [mailto:[EMAIL PROTE

Re: Oracle 10g and DBD::Oracle

2005-12-09 Thread Peter Santos
Reidy, Ron wrote: Peter, Can you repeat this same issue in SQL*Plus? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Peter Santos [mailto:[EMAIL PROTECTED] Sent: Thursday, December 08, 2005 9:00 AM To: dbi-users@perl.org Subject: re: Oracle 10g and DBD::Oracle

RE: Oracle 10g and DBD::Oracle

2005-12-09 Thread Reidy, Ron
This does not look the same. Where are the bind variables? -Original Message- From: Peter Santos [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 7:32 AM To: Reidy, Ron Cc: dbi-users@perl.org Subject: Re: Oracle 10g and DBD::Oracle No this issue is not repeatable in SqlPlus

RE: Oracle 10g and DBD::Oracle

2005-12-08 Thread Reidy, Ron
Peter, Can you repeat this same issue in SQL*Plus? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Peter Santos [mailto:[EMAIL PROTECTED] Sent: Thursday, December 08, 2005 9:00 AM To: dbi-users@perl.org Subject: re: Oracle 10g and DBD::Oracle Dear users, I&#

re: Oracle 10g and DBD::Oracle

2005-12-08 Thread Peter Santos
Dear users, I'm hoping to get some insight into why oracle creates 2 cursors for the same sql query when I execute a SELECT statement via my small little perl script. Here is what is happening .. My query uses 2 bind variables and when it is prepared oracle generates 1 cursor for my query. W

Re: DBD::Oracle won't install for Oracle 10G XE

2005-11-22 Thread Tim Bunce
On Mon, Nov 21, 2005 at 04:39:40PM -0800, Chuck Harding wrote: > The patch does not apply against the 1.16 version of the Makefile.PL as > the code that handles the 10g instant client is not in the file. Okay. So what happens when you apply it by hand? Tim.

Re: DBD::Oracle won't install for Oracle 10G XE

2005-11-21 Thread Chuck Harding
[ $cclib ]; +$opts{INC} = "-I$dbi_arch_dir $ccflags"; +$opts{dynamic_lib} = { OTHERLDFLAGS => "$::opt_g" }; +} + # --- special case for Oracle 10g instant client elsif (-e "$OH/libclntsh.so.10.1") { -- Charles D. (Chuck) Harding <[EMAIL PRO

Re: DBD::Oracle won't install for Oracle 10G XE

2005-11-21 Thread Tim Bunce
On Mon, Nov 14, 2005 at 02:49:02AM +0530, Anup Singh wrote: > Hello, > > Tried installing DBD::Oracle on Linux with Oracle 10G XE but it failed. I've implemented support for XE in the next release. Can't say when that'll be, but here's a patch that may work for you

DBD::Oracle won't install for Oracle 10G XE

2005-11-13 Thread Anup Singh
Hello, Tried installing DBD::Oracle on Linux with Oracle 10G XE but it failed. There is only one .mk file on rdbms/demo and it fails with that also. The .mk is available at: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/demo/demo_xe.m k and the file is attached to this mail Cheers

Re: Help: Oracle 10G installtion screwed up my perl

2005-10-21 Thread John D Groenveld
In message <[EMAIL PROTECTED]>, joe bayer writes: >On my WinXP sp2, I have perl 5.6.1 installed and a lot of scripts depend on th >at. Recently I installed Oracle 10g Version 2, it added a new sys

Help: Oracle 10G installtion screwed up my perl

2005-10-21 Thread joe bayer
Hi, group, I used DBI a lot but not experenced in setting up perl. On my WinXP sp2, I have perl 5.6.1 installed and a lot of scripts depend on that. Recently I installed Oracle 10g Version 2, it added a new system variable

RE: Serializing Storable.pm objects via DBI to Oracle 10g

2005-10-21 Thread Chris Fuhrman
ween Storable.pm and Oracle 10g. On Fri, 2005-10-21 at 06:38 +1000, Steve Baldwin wrote: > I haven't tried this on 10g, but what if you gzip your frozen object and > store it in a BLOB rather than a CLOB. Here's some code I use that works > fine in 9.2.0.6 ... > > my

RE: Serializing Storable.pm objects via DBI to Oracle 10g

2005-10-20 Thread Steve Baldwin
table_data' }); $sth_info_ins->execute; Steve -Original Message- From: Chris Fuhrman [mailto:[EMAIL PROTECTED] Sent: Friday, 21 October 2005 2:09 AM To: dbi-users@perl.org Cc: Jesse Throwe; Joseph Zarick; Carey Hall Subject: Serializing Storable.pm objects via DBI t

Serializing Storable.pm objects via DBI to Oracle 10g

2005-10-20 Thread Chris Fuhrman
Howdy, I seem to have encountered an odd quirk somewhere when using DBI against an Oracle 10g database. Here's the situation. I'm taking the following object, serializing using Storable.pm, and inserting it into a CLOB field in an Oracle 10g database running Solaris 9/sparc. $V

Re: Inserting UTF-8 string over 2000 chars to Oracle 10g - error ORA-01461

2005-08-13 Thread Jared Still
XML-files.) > > - setting NLS_LANG to various values does seem to affect the behavior. > > Thanks for your attention > Teemu Kivioja > > > == system === > Linux, 2.4.21-32.0.1.ELsmp > Oracle 10g, version 10.1.0.3.0 > Perl 5.8.7 built for i686-linux > DBI-

RE: :Oracle with Oracle 10g, Solaris 64 bit success...

2005-08-06 Thread Jeff Urlwin
al Message- > > From: Jeff Urlwin [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 05, 2005 8:43 AM > > To: dbi-users@perl.org > > Subject: DBD::Oracle with Oracle 10g, Solaris 64 bit success... > > > > For any of you who may have/had problems with building

RE: :Oracle with Oracle 10g, Solaris 64 bit success...

2005-08-04 Thread h-taguchi
- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED] > Sent: Friday, August 05, 2005 8:43 AM > To: dbi-users@perl.org > Subject: DBD::Oracle with Oracle 10g, Solaris 64 bit success... > > For any of you who may have/had problems with building > DBD::Oracle with Oracle 10g u

DBD::Oracle with Oracle 10g, Solaris 64 bit success...

2005-08-04 Thread Jeff Urlwin
For any of you who may have/had problems with building DBD::Oracle with Oracle 10g under Solaris, I got it working with a 32-bit perl by putting $ORACLE_HOME/lib32 in front of $ORACLE_HOME/lib in my LD_LIBRARY_PATH. The error you get relates to "Wrong ELF Class" if you don'

Re: Inserting UTF-8 string over 2000 chars to Oracle 10g - error ORA-01461

2005-07-29 Thread Teemu Kivioja
Sorry, Small, yet crucial error in my mail At 11:00 29.7.2005 +0300, you wrote: - setting NLS_LANG to various values does seem to affect the behavior. I meant to write - setting NLS_LANG to various values does _not_ seem to affect the behavior. Teemu Kivioja --

Inserting UTF-8 string over 2000 chars to Oracle 10g - error ORA-01461

2005-07-29 Thread Teemu Kivioja
arious values does seem to affect the behavior. Thanks for your attention Teemu Kivioja == system === Linux, 2.4.21-32.0.1.ELsmp Oracle 10g, version 10.1.0.3.0 Perl 5.8.7 built for i686-linux DBI-1.48 DBD-Oracle-1.16 locale: LANG=en_US.UTF-8 == code = use DBI qw(:utils); u

Oracle 10g binary_float format

2005-07-18 Thread John Legato
I have a table in an Oracle 10g database using the type binary_float. I can insert values into without any problems; however when I try to pull a value out I get garbage. Does DBD:Oracle version 1.16 support binary_float? If not will future version support it? I took a look at the JDBC

DBD::Oracle 10g - read write BLOB/CLOB

2005-07-13 Thread Jacqui Caren (IG)
A colleague asked for help with the below script. As I have not worked with 10g and could not find a relevant FAQ I thought perhaps you gentle folks would nudge me in the right direction :-) Jacqui [EMAIL PROTECTED]:~/tmp$ cat dbi-test.pl use strict; use DBI; #use utf8; #use bytes; #use enco

Re: dbd Oracle 10g AIX - install nightmare..... :

2005-07-11 Thread Lincoln A. Baxter
perl version ;) > > > -Original Message- > From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] > Sent: maandag 11 juli 2005 16:18 > To: Andrew > Cc: dbi-users@perl.org; oracle-oci@perl.org > Subject: Re: dbd Oracle 10g AIX - install nightmare. :< > > >

DBD::Oracle 10g BLOB/CLOB/vc2 and encodings

2005-07-11 Thread Jacqui Caren
A colleague asked for help with the below script. As I have not worked with 10g and could not find a relevant FAQ I thought perhaps you gentle folks would nudge me in the right direction :-) Jacqui [EMAIL PROTECTED]:~/tmp$ cat dbi-test.pl use strict; use DBI; #use utf8; #use bytes; #use enc

Re: dbd Oracle 10g AIX - install nightmare..... :

2005-07-11 Thread Andrew
dag 11 juli 2005 16:18 To: Andrew Cc: dbi-users@perl.org; oracle-oci@perl.org Subject: Re: dbd Oracle 10g AIX - install nightmare. :< You should post this to [EMAIL PROTECTED] On Sat, 2005-07-09 at 10:36 -0400, Andrew wrote: > Folks, > I hope this is correct group. > I j

Re: dbd Oracle 10g AIX - install nightmare..... :

2005-07-11 Thread Scott T. Hildreth
You should post this to [EMAIL PROTECTED] On Sat, 2005-07-09 at 10:36 -0400, Andrew wrote: > Folks, > I hope this is correct group. > I just can't install dbd:oracle on aix . Went though all archives... > nothing seems to work: > Here are details : > 10g 10.2 > This is perl, v5.8.0 built for ai

RE: dbd Oracle 10g AIX - install nightmare..... :

2005-07-11 Thread Bjorn.Naessens
ompile the makefiles with the right perl version ;) -Original Message- From: Scott T. Hildreth [mailto:[EMAIL PROTECTED] Sent: maandag 11 juli 2005 16:18 To: Andrew Cc: dbi-users@perl.org; oracle-oci@perl.org Subject: Re: dbd Oracle 10g AIX - install nightmare. :< You should

(Fwd) Perl DBD with Oracle 10g

2005-06-24 Thread Tim Bunce
- Forwarded message from Regis Biassala <[EMAIL PROTECTED]> - From: "Regis Biassala" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Perl DBD with Oracle 10g Date: Fri, 24 Jun 2005 10:15:34 +0100 Hi Tim, can you please help if you can...I know you are

(Fwd) RE: Perl DBD with Oracle 10g

2005-06-24 Thread Tim Bunce
- Forwarded message from Regis Biassala <[EMAIL PROTECTED]> - From: "Regis Biassala" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: RE: Perl DBD with Oracle 10g Date: Fri, 24 Jun 2005 10:38:17 +0100 Nevermind...go it workingbloody ORACLE_HOME p

Re: Building DBD::Oracle with Oracle 10g

2005-06-22 Thread Tim Bunce
On Wed, Jun 22, 2005 at 11:45:01AM +0100, David Cantrell wrote: > Just a quick note you might want to add to the README.clients file for > DBD::Oracle ... > > To build DBD::Oracle against a minimally built/configured instalation of > Oracle 10g 10.1, download and unzip the Inst

Building DBD::Oracle with Oracle 10g

2005-06-22 Thread David Cantrell
Just a quick note you might want to add to the README.clients file for DBD::Oracle ... To build DBD::Oracle against a minimally built/configured instalation of Oracle 10g 10.1, download and unzip the Instant Client from Oracle's web site and then either copy the libraries to somewhere yo

Oracle 10g database and DBI connectivity

2005-05-02 Thread Kevin Moore
Perl experts, I've got DBI and Apache configured to connect to an Oracle 9.2 database. I'm considering upgrading the database to 10g. Not expecting any problems but if anyone has gone that route and are willing to share any gotchas or additional suggestions i'd certainly appreciate it. Thanks, K

  1   2   >