Re: Can use SQL/NET v2 connect string in Perl module?

From: John D Groenveld <groenvel_at_tholian.cse.psu.edu>
Date: 1997/03/16
Message-ID: <5ghl31$5n6@tholian.cse.psu.edu>#1/1

In article <5gdos5$pai$2_at_news.hkol.com>, Pao Wan <paowan_at_drdun.com> wrote:
>Can I use
>&ora_login("((ADDRESS=(COMMUNITY=tcp)(PROTOCOL=TCP)(HOST=foo)(PORT=1521))",
>$user_id, $password) to connect a remote database?

Sure can, but I dont think the above is valid. Did you try the above with SQLPlus? Have you considered defining an alias for the above in tnsnames.ora?

This works for me:
$lda = ora_login("", q[scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= foobar)(PORT=1521))(CONNECT_DATA=(SID=foobarSID)))], "") or die $ora_errstr;

Happy perl'ng,
John
groenvel_at_cse.psu.edu Received on Sun Mar 16 1997 - 00:00:00 CST