Front page | perl.dbi.users |
Postings from March 2008
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: esimon@theiqgroup.com> 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:imharisa@nuskin.com] > 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:esimon@theiqgroup.com]> 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 foo@db1;> > 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> _________________________________________________________________Thread Previous | Thread Next