OraFAQ Forum: SQL & PL/SQL » ORA-22992 Error

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22992 Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-22992 Error [message #248838]

Mon, 02 July 2007 05:15

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi

I have created a database link to access remote table which has a CLOB column

When i try to query the data it says

ORA-22992 Cannot use LOB Locators used from remote tables

But i need to insert this data from remote table to a local table.

Please suggest me how can i acheive this.

Thanks in advacne.

Report message to a moderator

Re: ORA-22992 Error [message #250673 is a reply to message #248838]

Tue, 10 July 2007 15:24

toyway
Messages: 32
Registered: July 2002

Member

Check out this URL:
http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96591/adl04mng.htm#98328

HTH,
Oleg

Report message to a moderator

Re: ORA-22992 Error [message #250674 is a reply to message #248838]

Tue, 10 July 2007 15:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But i need to insert this data from remote table to a local table.
Don't pull the data to you, push it from the source database to the target database.

Report message to a moderator

Previous Topic:	CASE not working
Next Topic:	Simple way of doing spooling within spooling?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 23 21:13:05 CDT 2025