SQL Language (MOSC)

MOSC Banner

Insert BLOB via DBLINK

edited Apr 24, 2014 12:00PM in SQL Language (MOSC) 2 commentsAnswered

Hi,

I wanna insert the pdf file into the table from server B to server A via DB link.    But get the following error.  

Error

ORA-22992: cannot use LOB locators selected from remote tables

ORA-06512: at line 6

Created the table in Server A with column doc as BLOB.

Server A

CREATE TABLE cpo_docs (
  id    NUMBER(10)     NOT NULL,
  name  VARCHAR2(200)  NOT NULL,
  doc   BLOB           NULL
);

Execute the following script to insert record but error.

Server B
declare
v_bfile      BFILE;
v_blob       BLOB;
begin
  insert into cpo_docs@dblink(id,name,doc)
  values (3,3,empty_blob())
  return doc into v_blob;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center