Is it possible to call an Oracle Package in webMethods?

, ,
1

Hi,

I know I can call an Oracle procedure but what if the procedure resides in an Oracle package. Is it possible to call it? If Yes How?

Thanks in advance.

2

OK. I got it.I finally decided to use a function that returns a message instead of a procedure. I used pub.db:execSQL service and in my $dbSQL :
SELECT package_name.function_name FROM DUAL and it worked.

Nour.