OraFAQ Forum: Programming Interfaces » Copying Blob data from one database to another database

Home » Open Source » Programming Interfaces » Copying Blob data from one database to another database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copying Blob data from one database to another database [message #421596]

Wed, 09 September 2009 06:10

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

Michel Cadot
Messages: 68414
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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

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

Michel Cadot
Messages: 68414
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 20 05:26:23 CDT 2023