Anyone tried this with a remote database?

[email protected] (Rob McMillin) Mon, 03 Sep 2001 15:08:32 -0700
Newsgroups perl.dbi.oracle-oci
Message-ID <[email protected]>
Has anyone tried to build Oracle-OCI with a remote database? I'm running
out of ideas; I keep getting this error on test 13, which doesn't make
any sense:

OCIServerAttach returned ERROR at t/01base.t line 55.

Observing that the OCIServerAttach call in 01base.t doesn't look at the
$dbuser variable set earlier in the script (regardless of the setting of
the ORACLE_USERID environment variable), I tried patching the 01base.t
as follows:

***************
*** 52,58 ****
  ok OCIHandleAlloc($$envhp, my $svchp=0, OCI_HTYPE_SVCCTX, 0, 0), 0;
  bless $svchp => 'OCISvcCtxPtr';

! ok OCIServerAttach($svrhp, $errhp, 0, 0, OCI_DEFAULT), 0;

  print "get_oci_error\n";
  ok get_oci_error(undef, OCI_ERROR), "ERROR";
--- 52,58 ----
  ok OCIHandleAlloc($$envhp, my $svchp=0, OCI_HTYPE_SVCCTX, 0, 0), 0;
  bless $svchp => 'OCISvcCtxPtr';

! ok OCIServerAttach($svrhp, $errhp, $dbuser, length($dbuser),
OCI_DEFAULT), 0;

  print "get_oci_error\n";
  ok get_oci_error(undef, OCI_ERROR), "ERROR";

------

but it seems to have made no real difference. Am I missing something
here?

--
          http://www.pricegrabber.com | Dog is my co-pilot.