RE: Anyone tried this with a remote database?

[email protected] ("Rob McMillin") Thu, 6 Sep 2001 12:16:26 -0700
Newsgroups perl.dbi.oracle-oci
Organization PriceGrabber.com
Message-ID <001b01c13708$6cf053c0$290aa8c0@rob>
That's *build*, not connect to it.

> -----Original Message-----
> From: John Gorkos [mailto:[email protected]] 
> Sent: Thursday, September 06, 2001 11:08
> To: [email protected]
> Subject: Re: Anyone tried this with a remote database?
> 
> 
> 
> > 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
>