W O <[email protected]> wrote: > If the tables have always the same name you don't need the EXECUTE STATEMENT > >> >> >> I found a simple solution: >> >> EXECUTE STATEMENT 'insert into A select * from B'; >>
The execute statement form works better if the format of the tables is volatile. You avoid the "object in use" error if the procedure has been compiled. Good luck, Ann
