On Friday 14 December 2007 16:08, Adriano dos Santos Fernandes wrote:

> select * from proc(set x = 1, y = 2);
> execute statement 'select 1 from t where a = :a and b = :b' (set a =
> 1, b = 2);

In that case () are not needed - just:

select * from proc set x = 1, y = 2;

And so on.