Batch execution of procedure with return parameters

[Martin]

Hi Jiri,

As far as I know you can execute a procedure with return parameters and just ignore the return value, like EXECUTE PROCEDURE DoThis('a');

But when including that in a block it fails complaining about the return parameter.

EXECUTE BLOCK AS BEGIN 

EXECUTE PROCEDURE  DoThis('a');

INSERT INTO FOO(A) VALUES ('a');

END

I use

 

var script = new FirebirdSql.Data.Isql.FbScript(block);

script.Parse();

var fbe = new FirebirdSql.Data.Isql.FbBatchExecution(Connection as FbConnection);

fbe.AppendSqlStatements(script);

fbe.Execute();

        

Is this expected? Or is it FirebirdClient? Or the Firebird engine?

/M

[Jiří Činčura]

Hi, this is "limitation" of the engine.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

[Martin Ågren]

Ok, good to know. And btw, thanks for your excellent work

Martin

--
You received this message because you are subscribed to the Google Groups "firebird-net-provider" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-net-pro...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/firebird-net-provider/3005e69c-ea40-43ec-b624-5d98031d7cea%40www.fastmail.com.