If you want to access a table in the same oracle instance, but in a different schema, use this syntax for the table name: <schema>.<tableName>
If you want to access data in a remote schema, (1) create a database link in Oracle, then (2), use this syntax for the table name: <remoteSchema>.<tableName>@<DbLinkName> Axton Grams On 7/29/07, Ray <[EMAIL PROTECTED]> wrote: > Axton, Dave: I changed the Server name to the IP address of the remedy > server instead of the database server and it works. Any idea if I can > connect to a database table that is not the remedy database? If yes, how > would I do that? > > Thanks > Ray > Shellman, David wrote: > > > > Ray, > > > > My suggestion is to connect to your AR System instance with SQL Plus > > as the user aradmin. Then execute the sql statement. This eliminates > > any issue with the AR System. Any resulting Oracle error will be > > displayed. > > > > If the table doesn't have a public synonym you will proably need to > > execute the sql statement in the form of select value from > > [EMAIL PROTECTED] I remember this after I try select > > select value from [EMAIL PROTECTED] and get a table doesn't exist error. > > > > Often the other instance may require the same user name aradmin > > instead of a user named remedy. There's probably a way to connect as > > another user but I haven't tried and it may complicate the sql statement. > > > > Dave > > -------------------------- > > [EMAIL PROTECTED] (Wireless) > > > > ----- Original Message ----- > > From: Action Request System discussion list(ARSList) <[email protected]> > > To: [email protected] <[email protected]> > > Sent: Sun Jul 29 13:13:51 2007 > > Subject: Re: Newbie help with creating a SQL menu > > > > Hi Axton: I donot see anything in arerror.log. I have enabled logging on > > the remedy user client and donot see anything there as well. Not sure if > > his matters. This REMEDY user is not one created by remedy. It's a user > > our db admin has created for readonly access to a few views and tables. > > > > Thanks > > Ray > > Axton wrote: > > > 1. Is there anything else I need to do for the SQL menu to work? > > > Shouldn't be > > > > > > 2. How does the sql menu know what is the password for the REMEDY user > > > in the database? > > > It already has sessions to the Oracle instance used by Remedy; it just > > > uses those > > > > > > 3. How does it know the ORACLE_SID to be used for this query? > > > It already has sessions to the Oracle instance used by Remedy; it just > > > uses those, meaning it runs the sql against the Remedy instance as the > > > remedy schema owner > > > > > > Your arerr90 is more than likely indicative of another problem. Check > > > the arerror.log file for more info. > > > > > > Axton Grams > > > > > > On 7/29/07, Ray <[EMAIL PROTECTED]> wrote: > > > > > >> Hi: I have created a menu that should list value for all fields in a > > >> database. The SQL command for the menu I am using is the following. > > >> > > >> select distinct(LOCATION) from REMEDY.LOCATIONS > > >> > > >> I have associated this menu with a field in my form. When I click > > on the > > >> pulldown menu for the field, I get the following error > > >> > > >> ARERR [90] Cannot establish a network connection to the AR System > > server > > >> : 192.168.2.219 (0) : RPC: Program not registered > > >> > > >> The database I am connecting to is the database remedy uses and the > > >> database runs on a different server. I can log into that database fine > > >> using a sqlplus client. > > >> > > >> 1. Is there anything else I need to do for the SQL menu to work? > > >> 2. How does the sql menu know what is the password for the REMEDY user > > >> in the database? > > >> 3. How does it know the ORACLE_SID to be used for this query? > > >> > > >> Thanks > > >> Ray > > >> > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
