The following code example shows how to execute stored procedures and retrieve their results.

Procedure for Calling Stored Procedures

The query method can be used to call a stored procedure with the EXECUTE syntax, as described in EXECUTE Statements. As with Querying Data, the results will be given to a callback in batches.

db.open("...", (err) => {
    db.query("EXECUTE RunSystemStatusTool Id = 'clear_transients'", (err, rows, moreRows) => {
        for (var i = 0; i < rows.length; i++) {
            var row = rows[i];
            console.log("result = " + row["result"]);
        }

        if (!moreRows) {
            console.log("All rows have been processed");
        }
    });
});