Re: Anyone tried this with a remote database?

[email protected] (John Gorkos) Thu, 6 Sep 2001 13:07:38 -0500
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:

Here's a connect line that works for me:

my @server_buf_len = oci_buf_len($sid);
$status = OCIServerAttach($svrhp, $errhp, @server_buf_len, OCI_DEFAULT );
warn get_oci_error($errhp, $status) unless $status == OCI_SUCCESS;

$sid is straight from my tnsnames.ora

Hope that helps.

Has anyone used OCI to get real work done yet?  More specifically, has anyone 
used OCI with VARRAY objects (ala Spatial)?  I have hit the wall in 
converting readgeom.c into Oracle::OCI at the fetch, details to follow in a 
new message.

John Gorkos