Access BLOB field values for Oracle data link

Access Photo table

SELECT * from [email protected] where a1= ' 11111 ';

Error: ora-22992 Unable to use LOB locator selected from remote table

Change to the following method:

Method One:
DROP TABLE Temp
Create Table Temp AS SELECT * from [email protected] where a1= ' 002 ';
SELECT * from temp;

Method Two:

--Create a table with only one execution
Create Global temporary Table temp on commit delete rows as select * from [email protected] where 1=2;
Create table Temp2 as SELECT * from temp where 1=2;

--Multiple inserts can be executed

INSERT INTO temp SELECT * from [email protected] where gmsfhm= ' 140502199102260519 ';
INSERT INTO TEMP2 select * from temp;

SELECT * from Temp2;

Access BLOB field values for Oracle data link