Adriano,

A> 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}

A> It's current defined this way. That seems more a PSQL-like command.

A> We can change it if there is good arguments for. ;-)

I understand the benefits and the rationale in Alex's suggestion.
However, I think that:

- this is not flow control like FOR, IF or WHILE, so it deserves to be
seen somewhat differently; and
- it doesn't read very well IMHO.

OTOH, I don't have any suggestions better than BEGIN/END AUTONOMOUS
TRANSACTION. :-)

Ciao
--
Nando Dessena