Re: CLOB

From: Tiago <diariodastrilhas_at_gmail.com>
Date: Thu, 27 May 2010 05:42:21 -0700 (PDT)
Message-ID: <043b0662-6045-458a-9393-cf841deff647_at_m4g2000vbl.googlegroups.com>



On May 25, 12:30 pm, The Magnet <a..._at_unsu.com> wrote:
> Ok, I've seen all the notes on the ORA-22992 error:
>
> ORA-22992: cannot use LOB locators selected from remote tables
>
> Problem is that we are using a source table with a trigger that will
> update another table on a remote database over a DB link.  So, if you
> cannot update, how is this task to be accomplished?
>
> I have heard that there is a bug in 10g r2, which is what we are
> running.  But has anyone ever gotten this to work, and if yes, please
> share your work around.
>
> Thanks!

Could you create a local table, get the lob locator from it and then do a insert select on the remote table? I solved a similar problem this way, although it was a blob (almost the same, right?). My application generate a pdf using Oracle Reports and then upload the pdf to the remote database, which is the backbone of a web application. 10G r2 here too.

  • T
Received on Thu May 27 2010 - 07:42:21 CDT

Original text of this message