How do we do oracle function calls in webmethods

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

1 Like

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 :slight_smile:

Regards,
Nezha

Glad to hear. Share the steps you followed which will be helpful in future to others.

Thanks,

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,

Regards,
Nezha

Cool. Great for sharing what you did :smiley:

Thanks,