[Firebird-net-provider] NULL values in output parameters

[Marco B. <mar...@ai...>]

Hello,

 	I need some help with the Firebird .NET data provider v.1.5.

I'm using it on a ASP.NET project and I call a stored procedure that return
values into output parameters. When a field value in my table is null the
stored procedure returns NULL as parameter value. Using the FB .NET provider
the output parameter returned has always the default value (e.g.: 0 for
integer). Is it possible to return NULL value from database?


Here's the sp code:
[...]
CREATE PROCEDURE "sdgACTIVITYSTATUS" (
    "_ID" INTEGER)
RETURNS (
    ACCEPTED SMALLINT,
    "ORDER" SMALLINT,
    DESCRIPTION VARCHAR(50))
AS
BEGIN

SELECT
	
	"ACCEPTED",
	"ORDER",
	"DESCRIPTION"
			        
FROM
	"ACTIVITYSTATUS"
WHERE
	
	"ID" = :"_ID"

INTO
	:"ACCEPTED",
	:"ORDER",
	:"DESCRIPTION";

SUSPEND;
END
[...]


Thank you for your support,

--
Marco Brambilla
Aidiia