Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
how do we do oracle function calls in webMethods? We have utilities for making procedure calls in webMethods. But how do we make function calls to oracle?
thanks, Srinivas
hi community, i have the same question is there any body can answer please,
Regards, Nezha
Hi,
what exactly are you referring to when mentioning function calls?
In JDBC Adapter you can try to use “Custom SQL” service template…
Regards, Holger
As suggested by Holger, custom sql should work for your requirement. You may also explore SP for executing stored procedure.
R& D on CustomSQL will serve your purpose. Also there are a couple of threads on this forum, search those.
Thanks,
hi, thank you evreyone for yr answers, SP did the work
Glad to hear. Share the steps you followed which will be helpful in future to others.
hi, i just use a jdbc adapter to create a stored procedure,
As i see webMethods deal with functions like SP so it dosn’t make any difference it’s the same treatment,
Cool. Great for sharing what you did