DBI and DB:oracle modules

2009-02-04 Thread David Ehresmann
List , I want to install the DBI module on my linux server. It is not connected to a network. I am using Oracle EE 11g 11.1.0.7.0 and Red Hat Linux ES 4. My perl home is /usr/lib/perl. Which version of DBI and DBD::oracle do I use? I can go to this website: http://search.cpan.org/~timb/ and

Clash between DBI/Oracle::DBD and SOAP::Lite

2009-02-04 Thread Duncan Garland
Hi, We've got a script which segmentation faults whenever we try to use both DBI and SOAP::Lite. Early on in the script we make a connection to Oracle. Later on we do some SOAP calls and Signal SEGV at /usr/lib/perl5/Net/SSL.pm line 131 eval {...} called at /usr/lib/perl5/Net/SS

Re: How to iterate through database tables

2009-02-04 Thread pDale
On Tue, Feb 3, 2009 at 12:37 PM, Johannes Gritsch wrote: > I would say if a request like this should be solved without using Perl > variables the following applies: > > - the data model is bad > Truly. Especially if it really is changing underneath his feet. - creating views is a bad idea since

Installing DBD::Oracle-1.22 on Solaris10

2009-02-04 Thread Kelley Clanton
I am trying to install the DBD::Oracle 1.22 for Perl 5 on a Solaris 10 system; I have already successfully installed the DBI. The Oracle database is version 10.2.0.3 and the version of Perl is 5.8.4: Output of Perl -V: Summary of my perl5 (revision 5 version 8 subversion 4) configuration: Platf

Re: How to iterate through database tables

2009-02-04 Thread Johannes Gritsch
I would say if a request like this should be solved without using Perl variables the following applies: - the data model is bad - creating views is a bad idea since you would do DDL on a production system. That in return would deteriorate the execution/parse time quotient of the database instance

Re: How to iterate through database tables

2009-02-04 Thread Rudolf Lippan
On Tue, 3 Feb 2009 10:06:48 -0800, Douglas Wilson wrote: > On Tue, Feb 3, 2009 at 5:47 AM, Deviloper wrote: >> >> But some bad guy could showed up and force the poor developer not to use > perl-vars in SQL-Statements for security reasons. >> >> Is ist possible to use tablenames like normal bind

Permission problems with installing DBD::Oracle 1.22

2009-02-04 Thread Kelley Clanton
I am trying to install the DBD::Oracle 1.22 for Perl 5 on a Solaris 10 system; I have already successfully installed the DBI. The Oracle database is version 10.2.0.3 and the version of Perl is 5.8.4: Output of Perl -V: Summary of my perl5 (revision 5 version 8 subversion 4) configuration: Platf