Hi,

declare
a varchar2(200);
begin
a := 'create global temporary table sam as select * from emp';
execute immediate a;
end;

When executing this part,only the table structure is created..But the values from the emp table are not inserted.
We are using 8.1.6.

write back: sampath20@rediffmail.com

Sam