Getting returned value from a stored procedure in PostgreSQL

Question

I have a stored procedure in PostgreSQL:

CREATE OR REPLACE FUNCTION dosmth()
RETURNS boolean AS
$BODY$
BEGIN

RETURN FALSE;

 END;
 $BODY$
 LANGUAGE 'plpgsql' VOLATILE

From ado.net I need to retrieve the return value. I try to do the following:

   DbCommand cmd = DBTemplate.CreateStoredProcedureCommand(dbConnection, "dosmth");

   cmd.Parameters.Add(DBTemplate.CreateParameter(System.Data.DbType.Boolean,
                "@RETURN_VALUE", System.Data.ParameterDirection.ReturnValue));

   DBTemplate.ExecuteNonQuery(cmd);
   Boolean bl = Convert.ToBoolean(cmd.Parameters["@RETURN_VALUE"].Value);

Unfortunately this does not work telling me that the type DBNull cannot be converted to Boolean.
Any ideas?

Manoj Choudhari · Accepted Answer · 2019-10-03 13:15:11Z

1

Try using ExecuteScalar instead of ExecuteNonQuery. I seem to recall that ExecuteNonQuery doesn't return a result either.

edited Oct 3, 2019 at 13:15

Manoj Choudhari

5,6742 gold badges28 silver badges38 bronze badges

answered May 15, 2009 at 22:35

Onots

2,13621 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Getting returned value from a stored procedure in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related