I need to fetch multiple cursors from pg functions in Nodejs.
I have tried both kinds of function writing methods in PG as said in below link: http://www.sqlines.com/postgresql/how-to/return_result_set_from_stored_procedure
In PG Admin||| query tool i can able to view the output for multiple cursors by giving the name of it. I want to fetch the same from node js application, I'm using "pg-promise".
Option-1
db.func('get_data',
[
name,
key
])
.then(dbResult => {
console.log(" RES 1" + dbResult);
}).catch(error => {
console.log(error);
throw error;
});
Option-2
var retCursor1 = {};
var retCursor2 = {};
db.func('get_data',
[
name,
key,
retCursor1,
retCursor2,
])
.then(dbResult => {
console.log(" RES 1" + dbResult);
console.log(" RES 2" + retCursor1);
console.log(" RES 3" + retCursor2);
}).catch(error => {
console.log(error);
throw error;
});
get_data PG Fucntion will return 2 refCursors.
But No luck, can someone suggest what is the best way to fetch multiple cursor in Node js.
via Dinesh
No comments:
Post a Comment