Create or replace procedure GtempTbl_proc (Date1 Date, Date2 Date)
is 
   stmt varchar2(1000);
   stmt2 varchar2(1000);
Begin
    stmt  := 'create global temporary table t1 as select * from ics_sal_sdr1@livedb_vikdis ';
    execute immediate stmt;
    stmt2 := 'create global temporary table t2 as select * from ics_sal_sdr2@livedb_vikdis ';
    execute immediate stmt2;
End;