what is the process for converting a DB link script to webMethods? Do I need to write dynamic SQLs or making a package in oracle from teh script?
What does your DB link scripts contain and what does it do? Is it a huge script or just few lines?
It is a select from one database and insert into other database. Different tables and columns, 3 stored procedure about ten selects.
You can go for CustomSQL, DynamicSQL, StoredProcedure and StoredProcedureWithSignature adapter services
Please read : 6-5_JDBC_Adapter_Install_and_Users_Guide
You should rething your architecture. If you are using webMethods for executing a script which moves data from one db to another you are probably not using a good solution architecture. What are you trying to achieve?