Does the query work from the SQL client (SQLPlus or its equivalent whatever you use)...
Joe PS: Resending this after truncating email trail as my earlier response got rejected because of max number of lines.. Happens every now and then for some odd reason although that limit is not reached. The list engine has a weird method of calculating that I guess.. From: NormD Sent: Monday, June 06, 2011 8:33 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Direct SQL issue ** In one active link we are querying a view created by AR Server – in another we are trying to query a table created by AR Server – and in another we are trying to query a table created in the database by us that resides in the realm of the Aradmin user. Regards; Norm _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"