Blob field value for accessing the oracle Data Link, oracleblob
Access photo table
Select * from zp @ dblink1 where a1 = '201312 ';
Error: The ora-22992 cannot use the LOB locator selected from the remote table
Change to the following method:
Method 1:
Drop table temp
Create table temp as select * from zp @ dblink1 where a1 = '002 ';
Select * from temp;
Method 2:
-- Only one operation is required to create a table.
Create global temporary table temp on commit delete rows as select * from zp @ zhplink where 1 = 2;
Create table temp2 as select * from temp where 1 = 2;
-- Insert can be executed multiple times
Insert into temp select * from zp @ zhplink where gmsfhm = '000000 ';
Insert into temp2 select * from temp;
Commit;
Select * from temp2;
Problems with BLOB fields in Oracle
To obtain the values in BLOB, you must use the DBMS_LOB package in oracle.
How can I perform a search on the Internet?
1. Write a stored procedure first.
2 define the CLOB variable to accept the BLOB Value
3. Output the value of the clob variable.
The procedure is basically like this, hoping to help you
Add blob fields to oracle
Yes, the syntax is correct. I can test it here:
SQL> ALTER TABLE a ADD memo BLOB;
Table altered
SQL> ALTER TABLE a ADD memo2 cLOB;
Table altered
SQL> ALTER TABLE a ADD memo3 long;
Table altered
SQL> ALTER TABLE a ADD memo4 BLOB;
Table altered