ODBC Driver for AlloyDB

Build 23.0.8839

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 SelectEntries ObjectName = 'Account'", (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");
        }
    });
});

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839