NodeJS: Execute stored procedure and get OUT Parameter

Question

I want to call a stored procedure and get the return value in node. I'm able to do it 2 calls. 1 for calling procedure and the other for returning value.

I'm using mysql module

sqlcon.query("call CountOrderByStatus('done',@total);", function(err, rows, fields) {
                if (!err) {
                    console.log(rows);
                }
                else{
                    console.log('Error while performing Query.');
                    console.error(err)
                }
            });
            sqlcon.query("select @total;", function(err, rows, fields) {
                if (!err) {
                    console.log(rows);

                }
                else{
                    console.log('Error while performing Query.');
                    console.error(err)
                }
            });
        });

Is there any way to get it it one call?.

anilCSE · Accepted Answer · 2016-06-07 09:41:14Z

1

You can do something like this in node-mysql

sqlcon.query('SELECT 1; SELECT 2', function(err, results) {
  if (err) throw err;

  // `results` is an array with one element for every statement in the query:
  console.log(results[0]); // [{1: 1}]
  console.log(results[1]); // [{2: 2}]
});

answered Jun 7, 2016 at 9:41

anilCSE

2,4613 gold badges25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anil Kumar Over a year ago

That is throwing error.. Whenever we use 2 queries in single query

anilCSE Over a year ago

You need to use {multipleStatements: true} while creating connection. Something like this: var sqlcon = mysql.createConnection({multipleStatements: true});

Collectives™ on Stack Overflow

NodeJS: Execute stored procedure and get OUT Parameter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related