Hi,

I am new to DBI, and that may explain my question.

Using DBI::Proxy, I am trying to connect remotely to an Oracle
database whose datasource looks like this:

  'jdbc:oracle:thin:@127.0.0.1:1521:abc'

I tried passing a string to the call DBI->connect($ds, ..):

  $ds=DBI:Proxy:hostname=host.com;port=1521;dsn=<different values>...

Now that call always fails for a reason that I don't understand, with
the following error(s):

---- clip --------------------------------------
Argument " " isn't numeric in repeat (x) at
        /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/DBD/Proxy.pm 
line 63 (#1)
    (W numeric) The indicated string was fed as an argument to an operator
    that expected a numeric value instead.  If you're fortunate the message
    will identify which operator was so unfortunate.
    
Uncaught exception from user code:
        DBI 
connect('hostname=host.com;port=1521;dsn=DBI:jdbc:oracle:thin:@127.0.0.1:1521:isc','batman',...)
 failed: Cannot log in to DBI::ProxyServer: Unexpected EOF from server at 
/usr/lib/perl5/vendor_perl/5.8.0/RPC/PlClient.pm line 79.
 at ./test0.pl line 39
        
DBI::connect('DBI','DBI:Proxy:hostname=host.com;port=1521;dsn=DBI:jdbc...','batman','secret','HASH(0x82d7e38)')
 called at ./test0.pl line 39
---- clip --------------------------------------

The first error (warning?) points to the following line:

  my ($err,$state) = 
    ($errmsg =~ s/ \[err=(.*?),state=(.*?)\]//) ? ($1,$2) : (1,5 x ' ');

Can I ignore this error?

Am I using the wrong driver (DBI::Proxy), should I installed another
driver?

Thanks for your time!
--
        Claude

Reply via email to