SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update SQL Server Table from Oracle

BalVeJan 5 2010 — edited Jan 6 2010

Hi,

I have a doubt, Im working with a database in oracle 10g, and found a trouble trying to update a SQL Server database with a BPM system which retrieve data from this Oracle database... my question is...

How can I update this SQL Server database each 8 hours with the new information inserted in the Oracle database... i tried to use OpenQuery but shows the ORA-12514 TNS: Listener

I'll apreciate any help

This post has been answered by damorgan on Jan 6 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 3 2010

Added on Jan 5 2010

#listener, #server, #sql, #table, #update

2 comments

1,171 views