DB link Script

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?

1 Like