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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
