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
