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 >