Home » SQL & PL/SQL » SQL & PL/SQL » How to send a Blob variable to a remote server (11gR2)
How to send a Blob variable to a remote server [message #604741] Fri, 03 January 2014 11:13 Go to next message
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
Re: How to send a Blob variable to a remote server [message #604744 is a reply to message #604741] Fri, 03 January 2014 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You cannot do that.

Re: How to send a Blob variable to a remote server [message #604841 is a reply to message #604744] Sat, 04 January 2014 08:02 Go to previous messageGo to next message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
It may however be possible to write an application that makes two connections, one to database A and another to database B and then let the application ferry the BLOB data between them.

I cannot recall the last time I did this though, so you have some reading ahead of you, and there may be performance issues related to moving large amounts of data and possibly an issue with maximum sizes of your lob variables. You will have to find out.

Kevin
Re: How to send a Blob variable to a remote server [message #604857 is a reply to message #604841] Sat, 04 January 2014 14:03 Go to previous messageGo to next message
Amine
Messages: 375
Registered: March 2010
Senior Member

Any link to "the reading" you mentioned ?
Re: How to send a Blob variable to a remote server [message #604858 is a reply to message #604857] Sat, 04 January 2014 14:05 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+copy+blob
Previous Topic: ORA-00054: resource busy and acquire with NOWAIT specified or timeout
Next Topic: Sql query showing time problem
Goto Forum:
  


Current Time: Wed Apr 24 22:57:04 CDT 2024