W O <sistemas2000profesional@...> 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