Hi,
please have a look at this post that describes how to call stored procedures from within KNIME. This post might be also useful for you as it describes how to execute several statements within a single database node by using ;<SPACE> to separate the different statements.
Bye
Tobias