> Alex Peshkov escreveu:
> > And may I suggest slightly other syntax. We never write
> > BEGIN FOR SELECT ...
> > END FOR SELECT
> > May be for autonomous transaction a bit more traditionally-looking syntax can
> > be used, i.e.:
> > IN AUTONOMOUS TRANSACTION DO {complex_statement}
> It's current defined this way. That seems more a PSQL-like command.
>
> We can change it if there is good arguments for. ;-)

I, personally, prefer

BEGIN [AUTONOMOUS [<tran_options> TRANSACTION]]
...
END

where [<tran_options> TRANSACTION] may be implemented later

Regards,
Vlad