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!

Linked Server

Roald.vandenBergFeb 16 2012 — edited Feb 17 2012

We have a linked server in Sql Server 2005 that points to our Oracle 10.2.0.5 database. The new views I created in the Oracle database is displayed in Sql Server but when I query them no records are returned. The old views can be queried without any problems. What is strange is that when I added the data of the new view to the old view (union) none of the new data was displayed. Does anyone know what the issue could be.

Thanks
Roald

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2012

Added on Feb 16 2012

5 comments

164 views