SQL Procedure OUTPUT Param?

[dlbrown06]

There doesn't appear to be any clear documentation on how (or if) this is possible to view output params when a procedure is called.

Is this possible?

[khkiley]

+1

[ScheerMT]

I wasn't able to get this to work myself. The upstream library, mssql appears to correctly support output parameters on stored procedures..looks like a PR may be in need :)

For now, if you can, return select statements from your stored procedures to get the results out of them as a work around. I know its less than ideal but it will have to do

[dlbrown06]

I would have done that if I was starting from scratch. Unfortunately I was integrating with an existing database with many many procedures that other code bases were already touching.

[agagne122]

Has anyone as of yet been able to get Seriate to work with output parameters in SQL Server Stored Procedures? I am storing the two output parameters for the stored procedures in two variables defined in the following code:

var sql = require( "seriate" );

var connection = {
name: "example-1",
user: "user",
password: "pass",
host: "host_ip",
database: "Testing"
};

// Create endpoint /api/users for GET
exports.getDataSql = function(req, res) {
var results = {};
var Filename;
var Filename2;
sql.execute( connection, {
procedure: "GetData",
params: {
Name: {
type: sql.NVARCHAR(200),
val: req.body.DBName
},
SQLFilename: {
type: sql.NVARCHAR(1000),
val: Filename
},
BackupFilename: {
type: sql.NVARCHAR(1000),
val: Filename2
}
}

Are there any other steps I need to perform to get this to work?

Thanks!

[lbarbato]

+1