Cannot Invoke Stored Procedure?

[nievu]

Trying to create and invoke a stored procedure in node application. Could not find needed API to do so? Is it available?

[gperrow-SAP]

The exec function can be used to create a stored procedure and also to call one. Something like:

conn.exec( 'create procedure myproc() begin ... end', function( createErr ) {  
   if( createErr ) throw createErr;  
   conn.exec( 'call myproc()', function( callErr, result ) {  
      if( callErr ) throw callErr;  
      // result is the result set if the procedure returns one  
   });  
});

[zkewal]

How do we specify output args in stored procedure?