Hello Thomas.

If I create a stored procedure with autonomous transaction, it works fine!
But if I call these stored procedure in a table-trigger, it works not. The
trigger probably uses only one transaction. But the trigger isn't the right
place for the stored procedure-code.

Is there a possibility to use the (*) by inserting data? (insert into
table(*) select * from tableb. The second select all is possible, but for
the insert need to write down all table columns. And there are many
columns.

Thanks for the great hint with the autonomous transaction! It works great,
unfortunately not every level.

Best regards.


Olaf