I'll back Axton on that. It would be helpful if you can turn in your errors.
>From what you have done though I think I 'can see' where you might have gone wrong. I'm assuming from your description that the external database resides on an external database server since you mentioned you 'created a user' on that database too. If that is the case, it will not work. What you need to do is create a DB link, and permit the database user on the Remedy database to that DB link. Creating a user on the external database is not the same as permitting your ARADMIN user to the DB link. The ARADMIN user on your Remedy database has a different database user system ID from your user on the external database. Hope this helps. Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Axton Sent: Thursday, October 11, 2007 1:06 PM To: [email protected] Subject: Re: Inserting recordes from Remedy to an external database "I am getting errors here." The errors you are receiving would be helpful. Axton Grams On 10/11/07, Remedy Developer <[EMAIL PROTECTED]> wrote: > ** > Hello listers, > I have a certain requirement. I would like to insert > records into an external oracle database from remedy form. For this, I have > done the following: > 1) Created same database user on both remedy database and the other external > database which is on a different server. > 2) Created an entry in the listener.ora file on the remedy database and also > tnsping is successful. > 3) I have created a database link on the remedy database server. > > Now I want to use a filter with the DirectSQL action which would insert > records from the form to the external database using the following syntax: > insert into [EMAIL PROTECTED] link > values('Fieldname1','Fieldname2') > > I am getting errors here. I tried inserting into the same external table > using the same syntax from the SQL client from Remedy database server. > Please advise. > > Rgds, > Frank No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.8/1064 - Release Date: 10/11/2007 3:09 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
