Oracle Database Discussions

Hi all,

I tried to run procedure in local database, and procedure in local database had an insert sql statement, to insert data to table "A" in remote database which has table structure: (id NUMBER, test_clob CLOB). After exec the procedure in local database, it give me an error like:

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

My procedure in local database is look like:

Create or Replace procedure run_clob(p_id in number, p_file_name in varchar2)
AS
l_clob clob;
l_bfile bfile;
begin
insert into clob_table@dlog_link (id, test_clob ) values
(p_id, empty_clob() )
returning the_clob into l_clob;
l_bfile := BFILENAME ('TEMP_DIR', p_file_name);
DBMS_LOB.FILEOPEN(l_bfile);
DBMS_LOB.LOADFROMFILE(l_clob, l_bfile,
DBMS_LOB.getlength(l_bfile));
DBMS_LOB.FILECLOSE(l_bfile);
end;
/

I've searched around in Metalink base on the Note: 119897.1 and it said, Distributed LOBs are not supported. So, I just want to know are there anyway to handle with this error or any methods handle that.

Thanks,

Kevin