Submitted by: Konstantin Dombrugov (abracadabra)

Duplicates DNET770

Votes: 1

FirebirdClient does not return output of statements with "RETURNING" and I suspect that SP too.
I've fixed this issue for me but maybe there's a better way and imho this should be in official version.

Solution:
Data\Client\Managed\Version10\GdsStatement.cs
in public override DbValue[] Fetch()
replace
if (this.statementType != DbStatementType.Select &&
this.statementType != DbStatementType.SelectForUpdate)
{
return null;
}
with
if (this.statementType != DbStatementType.Select &&
this.statementType != DbStatementType.SelectForUpdate)
{
if (this.StatementType == DbStatementType.StoredProcedure && !allRowsFetched)
{
allRowsFetched = true;
return this.GetOutputParameters();
}
return null;
}