|
Re: sql server and oracle in a single form [message #512362 is a reply to message #504333] |
Sun, 19 June 2011 15:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I think so; however, not by keeping two different connections "alive" at the same time. I'd rather - on a database level - fetch MS SQL Server's data into an Oracle database (you'd use heterogeneous service to do that - it'll allow you to access data that is stored in an non-Oracle database as if it was within Oracle). Here's some more information.
Once you do that, you have a few options. One of them would be to create a form with two data blocks, each of them displaying data from its own data source (Oracle or MS SQL Server). Or, you could create a view as "union" (if possible) of these tables and create a single data block based on the view.
|
|
|