I'm running it successfully against Oracle 8.1.6, if that helps.
Try starting with DBI-1.18 and DBD-Oracle-1.07 from CPAN. Follow
instructions for building and installing those packages and pay *very* close
attention to README.java in the DBD distribution. If you have any problems
try rebuildin
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
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
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
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
[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', '
> 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
