Executing Stored Procedures
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 CreateWorksheet sheet = 'MyNewWorksheet'", (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"); } }); });