cancel
Showing results for 
Search instead for 
Did you mean: 

Executing store procedure from JDBC reciever

Former Member
0 Kudos

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 ?

thx

Shai

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos
Former Member
0 Kudos

use Action as EXECUTE.

use access as Input parameters.

prateek
Active Contributor
0 Kudos

U can use the stored proc directly using the EXECUTE action. No need for the OS level script.

Regards,

Prateek

Former Member
0 Kudos

in that case I am doing couple of insert statments and then want to execute store procedure

will it work?

prateek
Active Contributor
0 Kudos

Either u may add these insert statements as a part of Stored procedures or u may use multiple statement tags for multiple operations.

Regards,

Prateek