Re: cannot use LOB locators

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Tue, 03 Jul 2007 14:07:01 GMT
Message-ID: <pan.2007.07.03.14.07.01@verizon.net>

On Tue, 03 Jul 2007 05:07:33 -0700, sudheer.v538 wrote:

> Please let me what could be solution for this problem. I have to fetch
> data with single query to destination database and the table exist on
> another database with blob.
>
> But I am facing following error:
> ORA-22992: cannot use LOB locators selected from remote tables

Use a query tool which doesn't fetch locators but the BLOB column instead. DBD::Oracle does just that.

-- 
http://www.mladen-gogala.com

Received on Tue Jul 03 2007 - 09:07:01 CDT