> 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.

If the table structure matches, which is the case in your scenario I
think, you can simply do a:

insert into desttable select * from srctable;

Of course, you can also expand your source field list by adding
constants, e.g.:

insert into desttable select s.*, 1, 'a' from srctable;

if your destination table has additional columns.


Regards,
Thomas