Members   Search   Help    Register    Login   Home
Home » Developer & Programmer » Open Database Interfaces » Copying Blob data from one database to another database
Copying Blob data from one database to another database [message #421596] Wed, 09 September 2009 06:10 Go to next message
Praba
Messages: 2
Registered: September 2009
Location: India
Junior Member
Hi,

I am trying to copy blob data from one database to another database in C# code. But it throws me an exception as follows:

"This operation requires to use the same connection"

Pls help me to solve this problem.

Thanks in advance.

Regards,
Praba
Report message to a moderator
Re: Copying Blob data from one database to another database [message #421606 is a reply to message #421596] Wed, 09 September 2009 07:00 Go to previous messageGo to next message
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
As you didn't post the "operation that requires..." we can't say.

Regards
Michel
Report message to a moderator
Re: Copying Blob data from one database to another database [message #421635 is a reply to message #421606] Wed, 09 September 2009 10:12 Go to previous messageGo to next message
Praba
Messages: 2
Registered: September 2009
Location: India
Junior Member
Hi Michel,

The problem is I opened a connection to one db and copied the blob data and opened connection to another db and tried to paste the blob data. It was throwing the above mentioned error.

I got the solution Smile

I converted blob data into bytes and then stored the bytes into the new db.

I think, since blob is an Oracle class, we could not use a blob instance in another connection. Share your views on it.

Regards,
Praba
Report message to a moderator
Re: Copying Blob data from one database to another database [message #421642 is a reply to message #421635] Wed, 09 September 2009 10:30 Go to previous message
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
I have no idea of what you did so can't share anything.
Maybe if YOU start to share the code.

Regards
Michel
Report message to a moderator
Previous Topic:DBD:Oracle Install Problems RHEL
Next Topic:temp tablespace becomes full, not released by JDBC thin client ojdbc14.jar
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 13:53:41 CST 2009

Total time taken to generate the page: 0.13347 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.