Sender JDBC CC parameters with Stored Procedure Needed

[Former Member]

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.

[Former Member]

Done after having checked with the stored procedure at db itself.

S.

[Former Member]

HI,

You can execute stored procedures using JDBC sender CC...

SAP Help statement regarding the same is as below

Specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.

Try executing the stored procudure at database level and provide the same query at the sender CC and check...

HTH

Rajesh

[Former Member]

Rajesh, Query SQL statement parameter which I mentioned is true or not?

[Former Member]

to me looks true ..but your error says unable to find it means either your sp name or the user you used is not the correct one..

Rgds

Rajesh