Solved

Oracle linked server error

Posted on 2010-09-01
6
295 Views
Last Modified: 2012-05-10
Hello All,

I am trying to query an Oracle database from a linked 2005 SQL Server. I am pretty sure the error has something to do with the table name being DOCUMENT. I can query all other tables in the server except this one one, I even put the table name in brackets and get the same error(s). Code
0
Comment
Question by:Lobregon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 2

Expert Comment

by:MaxterJF
ID: 33582105
It's true that DOCUMENT is a reserved word in Oracle.  If you call "SELECT * FROM "EMRTST2".."ML"."DOCUMENT" that should be working (it's true that it's Pervasive way to call objects but oh well.... why not to try it?)
0
 
LVL 1

Author Comment

by:Lobregon
ID: 33582147
No that didn't work... I can query it just fine within an Oracle SQL Developer Screen.
PrtScr-capture-15.jpg
0
 
LVL 13

Expert Comment

by:riazpk
ID: 33584174
If you have SQL Server Management Studio, just check whether you can see the table when you choose the following options:
Linked Servers -> EMRTST2 -> Catalogs -> default -> tables
0
 
LVL 1

Author Comment

by:Lobregon
ID: 33588930
Yeah I can see it... Just cant Query it....
PrtScr-capture-16.jpg
0
 
LVL 1

Accepted Solution

by:
Lobregon earned 0 total points
ID: 33589121
I ended up making of a view of the table in Oracle and querying that view via SQL Server... I know just a band-aid but it works.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle perfomance issue. 4 51
Age Calculation from specific date 19 60
only show the last 365 days 6 35
Shared Service Environment 2 55
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question