You are welcome.
Joe D'Souza
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Remedy Developer
Sent: Friday, October 12, 2007 11:31 AM
To: [email protected]
Subject: Re: Inserting recordes from Remedy to an external database
**
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] ]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
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.14.8/1066 - Release Date: 10/12/2007
11:10 AM
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
