macro for creating a stored procedure in impromptu

[christenhusz]

Hi,

I am trying to create a macro which opens a catalog, use the stored procedure template, fills out a stored procedure and execute this.

Has anyone ever tried this and what are your findings? is it possible or not?

I am familiar with the execute, getparameter and setrprocedure methods but they don't give back the result set only a input or output parameter.

thanks for your help!

Christenhusz