Sender JDBC CC parameters with Stored Procedure Needed

32 Views

Hello Everyone,

We have followed http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm for setting the parameters for Connection tab as well as Processing tab.

Connection Tab parameters:

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

CONNECTION: jdbc:sqlserver://vodadev11:port;databaseName=voda_database

User Name : voda_db_user_dev

Processing tab parameters:

QualityOfService: ExactlyOnce

Poll Interval: 60

QuerySQL Statement: EXECUTE db_voda_por_action PLS Note this is stored procedure name and having doubt whether can I execute directly like this if not how ?

DocumentName : MessageType Name

DocumentName : Message Type Name space

Update SQL Statement : <TEST>

After setting all the above parameters I am seeing errors? Is there any problem with the parameters which I set or any?

Error

Database-level error reported by JDBC driver while executing statement 'EXECUTE db_voda_por_action'. The JDBC driver returned the following error message: 'com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'db_voda_por_action'.'. For details, contact your database server vendor.

BR

Swarna.