CODEWITHSUNDEEP
sqloracle-databaseplsqldblinklob
Belemnogo
Belemnogo

Reputation: 33

get CLOB and BLOB from remote Tables

I have two problems at the moment. 1- ORA-22992: cannot use LOB locators selected from remote tables Here is the script I am running:

CREATE OR REPLACE PROCEDURE merge_test(year in NUMBER)
IS
BEGIN
MERGE INTO SID_TEST SD
USING(
         SELECT t1.ID, TO_CHAR(t1.val) val, t.val2, TO_CHAR(t.val3) val3,  t.val4, 
                      TO_CHAR(t.val5) val5 FROM tab@dblink t, tab1@dblink t1
         WHERE t.id=t1.id and t.year=2010) R
ON (R.ID=SD.ID)
WHEN MATCHED THEN 
UPDATE SET SD.val = R.val,
           SD.val2 = R.val2,
           SD.val3 = R.val3,
           SD.val4 = R.val4,
           SD.val5 = R.val5

WHEN NOT MATCHED THEN
INSERT(SD.ID,SD.val,SD.val2,SD.val3,SD.val4,SD.val5)
VALUES(R.ID,R.val,R.val2,R.val3,R.val4,R.val5)
;

END;
/

val is a CLOB column and val3 and val5 arent BLOB column.

Upvotes: 0

Views: 543

Answers (0)

Related Questions