Wow, thanks!  I am confident that we are running at least the 10.2.0 client, 
but as far as getting the OCI client version (if that's
different), I'm not sure...
 
-- 
Eric


  _____  

From: John Scoles [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 06, 2008 6:02 AM
To: Eric Simon; dbi-users@perl.org
Subject: RE: Accessing Remote LOBs in Oracle



I am in the middle of the next DBD::Oracle release  I might be able to get it 
in in a week or so if you want it there.
 
Does not look too complicated but I am not sure which OCI client you have to 
use.
 
Let me have a quick look at it this AM and get back to you later today.
 
You could try writing it youself but OCI is not something you can pick up in 
5min.  I been working in it for two years now and I
still know nothing.
 
cheers
John Scoles

> From: [EMAIL PROTECTED]
> To: dbi-users@perl.org
> Subject: RE: Accessing Remote LOBs in Oracle
> Date: Wed, 5 Mar 2008 16:19:42 -0600
> 
> I'm barely familiar with stored procedures. How would you leverage a stored 
> procedure here? Would it be to create an actual table
> in db2 and have a stored procedure update a mirrored table in db1?
> 
> Also, I'm paranoid about the stored procedure introducing more overhead, as I 
> am moving LOB data frequently in and out of these
> tables.
> 
> 
> -----Original Message-----
> From: Ian Harisay [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, March 05, 2008 3:06 PM
> To: dbi-users@perl.org
> Subject: RE: Accessing Remote LOBs in Oracle
> 
> Have you tried handling this thru a stored procedure? I think that would make 
> the database link transparent to you.
> 
> -----Original Message-----
> From: Eric Simon [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 05, 2008 1:13 PM
> To: dbi-users@perl.org
> Subject: Accessing Remote LOBs in Oracle
> 
> Hi,
> 
> Has anyone else needed to write into LOB columns on remote Oracle databases 
> through a database link (created by the Oracle
statement
> 'CREATE PUBLIC DATABASE LINK ...'). For example, we have this:
> 
> In Instance 1: (db1)
> ====================
> CREATE TABLE foo (
> a NUMBER(10),
> b CLOB
> );
> 
> In Instance 2: (db2)
> ====================
> CREATE SYNONYM foo FOR [EMAIL PROTECTED];
> 
> Our Perl script creates a database handle connected to db2 and tries to 
> insert values into foo (which, because it is a synonym
will
> insert the values into the foo table on db1), but fails with the following 
> error:
> 
> Fatal: DBD::Oracle::st execute failed: ORA-22992: cannot use LOB locators
> selected from remote tables (DBD ERROR: error possibly near <*> indicator
> at char 36 in 'INSERT INTO foo (a,b) VALUES (:p1,:<*>p2)') [for Statement
> "INSERT INTO foo (a,b) VALUES (:p1,:p2)" with ParamValues: :p1='1',:p2=undef]
> 
> As of Oracle 10gR2, Oracle claims to provide the facility to access remote 
> LOBs through OCI (and they provide a code example):
> 
> http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14249/adlob_data_interface.htm#CACIFCJF
> 
> Is there anyone capable of incorporating this new facility into DBD::Oracle? 
> I'm new to this package, but I could try if I was
> pointed in the right direction. Thanks!!
> 
> --
> Eric Simon
> 



  _____  

Reply via email to