Fixing ORA-22992 "cannot Use LOB Locators Selected from Remote Tables" Error

smallwei 9:43 pm on November 6, 2009 | Answers: 1    
Tags: 9i database, cannot (13), error (74), fixing (5), lob, oracle (120), oracle 9i database, use (63)

Rate Knowledge:

 Loading ...

• smallwei 9:43 pm on November 6, 2009
  

  There is a bug on 9i,10g, and 11g that is related to this error. It is being fixed in 11.2. It can also be backported for previous 9i, 10g and 11g releases under the latest patchsets.

  You may also do a workaround as follow:

  Modify the affected SQL by adding the TO_CHAR function. For example:

  -- Original SQL:
  
     SELECT NVL2('a', 'b','c' ) FROM dual@remote_db;
  

  
  

  -- Modified SQL:
  
     SELECT TO_CHAR(NVL2('a','b','c')) FROM dual@remote_db;