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