on 03-28-2006 1:12 PM
Hi All,
How can i execute the storedprocedure using JDBC sender adapter. I need to trigger the storedprocedure once in every hour. so i would like to use the JDBC sender adapter. My question is what is the SQL i need use in the SQLstatement parameter..?? I don't want to send parameters and not expecting any return values. It should just trigger the procedure.
Thanks in adv.
Regards,
Hi Muarli,
If you want no rows to be selected, then just make sure that the a dummy select statement is provided in your Stored Procedure and that this statement will not return anything.
like, select * from tab where id=NULL over say a PRIMARY KEY of the table.
You can manipulate the SELECT Statement not to return anything and it will work good.
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Murali,
it is possible to execute a stored porcedure using a sender JDBC adapter.
Just Specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.
This will have to be done for your SELECT statement in JDBC adapter. ALso, make the UPDATE as either TEST, if you dont want any updations or give an UPDATE statement for the UPDATE query.
Set the polling interval of your JDBC adapter to 1 hour and it will work like u want.
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi murali,
from the online documentation,
<b>The expression must correspond to the SQL variant supported by the relevant JDBC driver</b>
Just try to execute the same stored procedure from your Database client and use the query that you use in your database client to execute it from your JDBC sender adapter.
I guess this should work,
Regards,
Bhavesh
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.