Does anybody succeed using jdbc command in reciever jdbc adapter to execute store procedure without parameters ?
or do I must writing a script in OS Level ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use Action as EXECUTE.
use access as Input parameters.
U can use the stored proc directly using the EXECUTE action. No need for the OS level script.
in that case I am doing couple of insert statments and then want to execute store procedure
will it work?
Either u may add these insert statements as a part of Stored procedures or u may use multiple statement tags for multiple operations.