Hi!!
I have an agent in lotus which calls a stored procedure in oracle. I connect to oracle through an odbc connection with the server's dsn name, user id and password. If, at a later time, I would want to use some other oracle server, I would have to change the dsn name, user id and password in the agent's code. How can I avoid doing this? Is there any way of dynamically passing these connection parameters to the agent?
Thank you.
I have an agent in lotus which calls a stored procedure in oracle. I connect to oracle through an odbc connection with the server's dsn name, user id and password. If, at a later time, I would want to use some other oracle server, I would have to change the dsn name, user id and password in the agent's code. How can I avoid doing this? Is there any way of dynamically passing these connection parameters to the agent?
Thank you.