How to send a Blob variable to a remote server [message #604741] |
Fri, 03 January 2014 11:13 |
Amine
Messages: 375 Registered: March 2010
|
Senior Member |
|
|
Hi all,
I want to insert a blob variable to a remote table through a procedure.
In a remote database I have this procedure :
create or replace procedure insert_blob(p_blob in blob) is
begin
execute immediate 'insert into images values (:x)' using p_blob;
end;
/
and in another database, I want to execute
declare
l_blob blob := empty_blob();
begin
insert_blob@remote_server(l_blob);
end;
/
And this causes an error. How to achieve my requirement.
Thanks in advance,
Amine
|
|
|
|
|
|
|