SQL & PL/SQL

Hi,

I have created temporary table like:

create global temporary table temp on commit preserve rows as
select * from t1,t2 where.....;

Table got created. when i am inserting data by issuing :
sql>insert into temp select * from t1,t2 where ....; it is inserting.

But when i am trying to execute the same insert stmt in procedure,proc is executed.But there is no data in temp table.Why ?

Any helps.

Thanks.