Thanks Joe,
Actually the database link had to be created with aradmin
user giving the correct permissions and that worked.
Rgds,
Frank
On 10/12/07, Joe D'Souza <[EMAIL PROTECTED]> wrote:
>
> ** 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]
> <[email protected]>]On 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
> __20060125_______________________This posting was submitted with HTML in
> it___
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
