Home » SQL & PL/SQL » SQL & PL/SQL » Oracle BLOB DATA (ORACLE,PLSQL)
Oracle BLOB DATA [message #660394] Wed, 15 February 2017 13:33 Go to next message
bkumar
Messages: 3
Registered: February 2017
Junior Member
How can i return blob data from one database to another datbase with out using temporary tables and Mviews. Can you please suggest me approach to solve my issue.
Re: Oracle BLOB DATA [message #660395 is a reply to message #660394] Wed, 15 February 2017 13:39 Go to previous messageGo to next message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
Transportable tablespace
Re: Oracle BLOB DATA [message #660397 is a reply to message #660395] Wed, 15 February 2017 13:44 Go to previous messageGo to next message
bkumar
Messages: 3
Registered: February 2017
Junior Member
Can you please elaborate solution..
Re: Oracle BLOB DATA [message #660398 is a reply to message #660397] Wed, 15 February 2017 13:50 Go to previous messageGo to next message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
bkumar wrote on Wed, 15 February 2017 11:44
Can you please elaborate solution..
incapable or unwilling to use GOOGLE yourself?
Re: Oracle BLOB DATA [message #660399 is a reply to message #660397] Wed, 15 February 2017 13:55 Go to previous messageGo to next message
bkumar
Messages: 3
Registered: February 2017
Junior Member
I mean i have a procedure(X) and it is returning blob...I am calling x procedure from remote database..How can you handle it.
Re: Oracle BLOB DATA [message #660400 is a reply to message #660399] Wed, 15 February 2017 14:11 Go to previous message
BlackSwan
Messages: 25795
Registered: January 2009
Location: SoCal
Senior Member
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:696224943687
Previous Topic: Global Temporary table storage
Next Topic: Create a Job to run Oracle Package stored procedure
Goto Forum:
  


Current Time: Thu Jan 18 09:02:59 CST 2018

Total time taken to generate the page: 0.01599 seconds