oracle connect ; manual eror handling

From: JONL (jon.m.landenburger_at_verizon.com)
Date: 03/18/05

  • Next message: iorcc_at_yahoo.com: "ANN: 2005 International Obfuscated Ruby Code Contest (IORCC)" 
    Date: 18 Mar 2005 12:43:57 -0800

    Have been connecting to oracle using the following with success
    my $dbHandle = DBI->connect($sConnectString, $sUsername, $sPassword );
    adding ,\%attr after password permits me to set the db handle options

    But now we use a different connect syntax to support OS authentication:
    my $sLoginString = "$sUsername/$sPassword";
    my $dbHandle = DBI->connect($sConnectString, $sLoginString) ;

    this will work but if I add \%attr after the LoginString, the connect
    complains that I gave it an empty password. What I need to be able to
    do is to use the second syntax but still be able to set dbh options.
    ANy ideas?

  • Next message: iorcc_at_yahoo.com: "ANN: 2005 International Obfuscated Ruby Code Contest (IORCC)"