Alex Peshkov escreveu:

>> Don't introduce ambiguities with boolean expressions, please. :-)
>>
>
> EXECUTE STATEMENT S (a(CURRENT_TRANSACTION), b(CURRENT_CONNECTION));
>
> Does this look better for you?

No, this is ambiguous with function call syntax.

I think something more or less:
EXECUTE STATEMENT S (@a = CURRENT_TRANSACTION, @b = CURRENT_CONNECTION);

would be ok. And I also want a syntax that could be used to call procedures:
select * from sp(@p1 = 1, @p2 = 2)

But @ is used to denote client parameters in ADO.NET. I think we need
opinions if this could cause problems.


Adriano