"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"
