Getting returning value from a stored procedure in postgres?
Try using ExecuteScalar instead of ExecuteNonQuery. I seem to recall that ExecuteNonQuery doesn't return a result either.
A stored procedure and user-defined function (UDF) is a set of SQL and procedural statements (declarations, assignments, loops, flow-of-control etc.) that stored on the database server and can be invoked using the SQL interface. In PostgreSQL, both stored procedures and user-defined functions are created with CREATE FUNCTION statement. Usually the purpose of a user-defined function is to process the input parameters and return a new value.
Many reporting tools (Crystal Reports, Reporting Services, BI tools etc.) allow you to specify a query (SQL SELECT statement) or a stored procedure returning a result set to define a data set for a report. Stored procedures are very useful when you need to perform complex calculations before the data is available for a report.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
Getting value from stored procedure in another stored procedure?
How to get the output value from stored procedure from another stored procedure in a tabular format?
How to call a stored procedure from another stored procedure in oracle?
Stored Procedure runs slowly when being called from another stored procedure?
Concat results in a single string returning null value in stored procedure?
Can a sub-procedure procedure lock and modify the same rows FOR UPDATE that its calling procedure already locked?