Solved

Select from different data sources on a command

Posted on 2011-03-17
4
383 Views
Last Modified: 2012-05-11
I have a command on one data connection and I have to reference  a table that only exists on a different data connection for the same report.

It gives me a message for table ro view does not exist because it doesn't find that table on that connection. WHat am I doing wrong, how can I reference a field from a different data connection. I tried playing with links but it did not work. Is there a way to do select statemenets on the select expert? it doesn't have the from and where keywords...
0
Comment
Question by:patsylipp
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 35162325
You can't.

You can try using the Select Expert by setting the fields you want to link together =
The Select Expert text is the WHERE clause for the SQL.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35162329
Remember, when you are building a COMMAND, you are working within that data connection so you can only reference objects that fall within the data connection.

mlmcc
0
 
LVL 8

Accepted Solution

by:
POracle earned 500 total points
ID: 35164153
create database link from database where you are connected to other database from where you want to access table, call it dblnk

then use,

select * from table@dblnk
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 35166964
Agree with comments made by both mlmcc and POracle.  If you're using a SQL Command, you are limited by the constraints of what's available through SQL and your data connection.  DB linking might be a solution.

~Kurt
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

930 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now