Re: Installing Perl DBI and Oracle DBD in AIX 5.1

2004-10-19 Thread Pablo Salinas
AIL PROTECTED]> escribió: > > Hi there, > > I have an AIX 5.1 machine and I wish to > use > > the perl DBI and oracle DBD in this machine. I > have > > tried to install them by downloading DBI-1.45.tar > and > > DBD-Oracle-2.15.tar files from >

Re: Installing Perl DBI and Oracle DBD in AIX 5.1

2004-10-15 Thread Wiggins d Anconia
> Hi there, > I have an AIX 5.1 machine and I wish to use > the perl DBI and oracle DBD in this machine. I have > tried to install them by downloading DBI-1.45.tar and > DBD-Oracle-2.15.tar files from http://www.cpan.org/ > This is a rather difficult combination an

Installing Perl DBI and Oracle DBD in AIX 5.1

2004-10-15 Thread Pablo Salinas
Hi there, I have an AIX 5.1 machine and I wish to use the perl DBI and oracle DBD in this machine. I have tried to install them by downloading DBI-1.45.tar and DBD-Oracle-2.15.tar files from http://www.cpan.org/ So, I uncompressed the DBI-1.45.tar file and followed the README file

RE: Perl DBI and Oracle

2002-06-28 Thread Jackson, Harry
Title: RE: Perl DBI and Oracle > -Original Message- > From: Joe Raube [mailto:[EMAIL PROTECTED]] > > > I think that if you posted some code, we could give better assistance > with this matter. This is the code that I am using to connect but if I am una

RE: Perl DBI and Oracle

2002-06-27 Thread Joe Raube
I think that if you posted some code, we could give better assistance with this matter. --- "Jackson, Harry" <[EMAIL PROTECTED]> wrote: > > I retrieve a load of records but because the default linesize means > that it > comes out on multiple lines when printing to a CSV. I suppose I > could

RE: Perl DBI and Oracle

2002-06-27 Thread Jackson, Harry
> -Original Message- > From: Joe Raube [mailto:[EMAIL PROTECTED]] > > "set linesize" > > is a SQL*Plus command to control the size of an output line > > dbi is used for manipulating data from a database, the output is > controlled by you... > > What are you trying to accomplish?

Re: Perl DBI and Oracle

2002-06-27 Thread Joe Raube
"set linesize" is a SQL*Plus command to control the size of an output line dbi is used for manipulating data from a database, the output is controlled by you... What are you trying to accomplish? -Joe --- "Jackson, Harry" <[EMAIL PROTECTED]> wrote: > Ho do you > > set linesize 1000; >

RE: Perl DBI and Oracle

2002-06-27 Thread Bob Showalter
> -Original Message- > From: Jackson, Harry [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 9:35 AM > To: '[EMAIL PROTECTED]' > Subject: Perl DBI and Oracle > > > Ho do you > > set linesize 1000; > > using dbi for Oracle

Perl DBI and Oracle

2002-06-27 Thread Jackson, Harry
Ho do you set linesize 1000; using dbi for Oracle. I have tried inserting it before the "select" statement and putting it in its own "prepare" statement but neither have worked. Google has got very little on this when I searched for it. I would appreciate a decent link to how to do this sort of

RE: DBI and Oracle 8I

2001-07-06 Thread Ross, Jonathan C.
s try rebuilding your Perl with -lthread; that did it for me. Regards, Jonathan -Original Message- From: Conrad, Bill (ThomasTech) [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 4:27 PM To: [EMAIL PROTECTED] Subject: DBI and Oracle 8I Hi All I don't know if this is the r

DBI and Oracle 8I

2001-07-05 Thread Conrad, Bill (ThomasTech)
Hi All I don't know if this is the right place to ask this but here goes. Please direct me to other lists if appropriate. I would like to use Perl to access are Oracle 8I version 817 database on Solaris 2.6. 1) Do the current DBI packages support this? 2) If so,

DBI and Oracle error

2001-06-01 Thread Swalve, Lane
I am using activeperl 5.6.1 on a Windows NT box. I have recently installed the DBI module with the oracle DBD driver. However when i try to use the module I get a error that reads like this install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::O

Re: DBI and Oracle

2001-04-25 Thread Michael Lamertz
Emma Wermström (EMW) ([EMAIL PROTECTED]) wrote: > Thank you! > > I think you understand my dilemma. > Installing DBD::Oracle requires that I install "some Oracle software such as Pro*C", >according to the DBD::Oracle README. Do you know exactly what I need? > I've already installed Apache::DBI a

RE: DBI and Oracle

2001-04-25 Thread Collin Rogowski
Apache::DBI and I'm running one of the latest versions of >perl and mod_perl. > Thanks again, > > Emma > > -Original Message- > From: Michael Lamertz [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 25, 2001 1:11 PM > To: Emma We

RE: DBI and Oracle

2001-04-25 Thread Emma Wermström (EMW)
ersions of perl and mod_perl. Thanks again, Emma -Original Message- From: Michael Lamertz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 1:11 PM To: Emma Wermström (EMW) Cc: '[EMAIL PROTECTED]' Subject: Re: DBI and Oracle Emma Wermström (EMW) ([EMAIL PROTECTED]) wr

Re: DBI and Oracle

2001-04-25 Thread Michael Lamertz
Emma Wermström (EMW) ([EMAIL PROTECTED]) wrote: > Hi! > > I'm a beginner (to databases aswell as perl) trying to use perl code embedded in >html to access an Oracle database. The trouble I'm having is that the database >requires two login procedures. The first one to access the actual database

DBI and Oracle

2001-04-25 Thread Emma Wermström (EMW)
Hi! I'm a beginner (to databases aswell as perl) trying to use perl code embedded in html to access an Oracle database. The trouble I'm having is that the database requires two login procedures. The first one to access the actual database and a second one to access SQL (sql+) within the datab

RE: DBI and ORACLE

2001-04-23 Thread Nutter, Mark
[Copying the list on a reply to a private email, with permission] A placeholder consists of a single question mark ("?") in your query statement. It replaces a single value in your SQL statement. For example: Without placeholders: INSERT INTO MYTABLE VALUES ('Mark', 'Nutter', 'foo', 'bar', '

RE: DBI and ORACLE

2001-04-20 Thread Nutter, Mark
> My results are in a comma delimited file. I need to read > through the file > adding each line as a record in the table using the SQL: > > my $query1=<<"QUERY"; > INSERT INTO DIFFAMNTS VALUES > ('PK',9197,171509,'THIS IS A TEST2 > ROW','AA',1,77120,101032) > QUERY > > Obviously

DBI and ORACLE

2001-04-20 Thread Mark Martin
Hi all, has anybody got experience with DBI. I'm retrieving data from Oracle and running programs quite nicely on te output but after that I need to get my results back into a table. My results are in a comma delimited file. I need to read through the file adding each line as a record in the tabl