| Move data from one DB to other without DB link and using dot net [message #569618] |
Tue, 30 October 2012 06:33  |
srinivas.k2005
Messages: 404
Registered: August 2006
|
Senior Member |
|
|
Hi,
I have database A and B , we are strictly restricted to not to create any DB links between these database.
In database A based on complex logic we in a stored procedure we populate the data to table type..now dot net will take this table type data and insert the same in database B.
Question here :
1.When we try to bulk collect all the data into table type , i am getting error operand exceeds limit, but it is mandate to put all data in one short to table type as dot net will take that and insert into B database.
2.Is there any good logical method to achieve this in a simple way.
Thanks,
SRK
|
|
|
|
|
|
| Re: Move data from one DB to other without DB link and using dot net [message #569624 is a reply to message #569620] |
Tue, 30 October 2012 07:16  |
srinivas.k2005
Messages: 404
Registered: August 2006
|
Senior Member |
|
|
Thanks for the reply...
I tried to convince your method, but Dot Net guy said he needs the data in plsql table type from my procedure, they are just calling my procedure in Database A and the procedure does complex logic and returns the OUT parameter as plsql table type with huge data (sometimes operand exceeds limit error) and that OUT pramater the Dot Net uses and inserts into B database.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
