Issue related to webmethods 7.1.2 adapter service


We have moved our application Db from SQL to oracle. While calling the stored procedure from webMethods adapter service I was getting an error like: Adapter can’t be invoked as some input parameter is required.
To resolve the above issue I have configured the required input value under the parameter tab of the adapter service, but after making the changes when I run the adapter instead of the required result \value I am getting the parameter name in the result panel.
Can anyone please assist me on what exactly I need to change in my adapter service to get the correct output without exception?
Thanks in advance.


In the calls tab please give all your output fields, and i the paramaters tab give all your input fields, that should work fine. Suggest you read the jdbc adapter user’s guide to get a better hold on the working concepts of using SPC’s in your code.