How do we do oracle function calls in webmethods

, ,
1

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

2

hi community,
i have the same question is there any body can answer please,

Regards,
Nezha

3

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
4

As suggested by Holger, custom sql should work for your requirement. You may also explore SP for executing stored procedure.

5

R& D on CustomSQL will serve your purpose. Also there are a couple of threads on this forum, search those.

Thanks,

6

hi,
thank you evreyone for yr answers, SP did the work :slight_smile:

Regards,
Nezha

7

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

Thanks,

8

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

9

Cool. Great for sharing what you did :smiley:

Thanks,