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.