PDA

View Full Version : Calling DB2 Stored Procedure using WMDB pubdbcall


schung888
05-19-2005, 10:43
Folks

We are running on webMethods 6.0.1 SP2 with WMDB Adapater

The DB2 Driver that we are using is DataDirect ver 3.4

We would like to invoke a DB2 stored procedure using pub.db:call

We are able to use pub.db:getProcs to show that the Stored procedure exist.

However, when we use pub.db:getProcInfo, webMethods returns with an error

com.wm.app.b2b.server.ServiceException: No information available for procedure PTL_BAXS_SELECT

Is that something related to authorization ?? where the stored procedure is catalogued, AuthID, etc, etc.....

Thanks in advance