Snap for JDBC that runs stored procedure and returns status and results...like SQL execute snap

Hi John:

For which database? You can do quite a bit in the SQL Execute snap – SELECT, CREATE, even invoke a stored function (well, at least for Oracle). Oracle has the notion of IN (parameters passed in) and OUT parameters (values returned from the procedure), and you can even define a stored function which returns a value and also a result in an OUT parameter – don’t know that this is a common pattern though.

function f1(x_out OUT varchar2) return number AS
BEGIN 
    x_out := 'OK';
    RETURN 1; 
END f1; 

We do support stored procedures for most of our databases, but to what extent depends on the db.