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 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 Wermström (EMW)
Cc: '[EMAIL PROTECTED]'
Subject: Re: DBI and Oracle
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 and a
>second one to access SQL (sql+) within the database. How can I implement this using
>the
> $dbh->connect(....) ?
I'm not sure I understand what you mean. As I interprete your question,
the first login happens during some telnet/ssh connect on the machine,
and the second is the SQL+'s username and password prompt?
Using DBI things are different. DBD::Oracle can talk directly to a
database listener on a foreign machine, without the need to open a shell
on that machine or start SQL+, so providing the $DBI->connect(...) with
the correct data - the one you type into SQL+ - should be sufficient.
--
If we fail, we will lose the war.
Michael Lamertz | [EMAIL PROTECTED] / [EMAIL PROTECTED]
Nordstr. 49 | http://www.lamertz.net
50733 Cologne | Work: +49 221 3091-121
Germany | Priv: +49 221 445420 / +49 171 6900 310
