Hi, Ive got the simplest question on earth, hell i should be able to answer it but for some reason it wont work.

I have this line in my plsql program

insert into migrate.apc_call_details
select * from migrate.apc_call_details_07
where rownum between from_row_num and to_row_num;

where from_row_num and to_row_num are variables.

Theses variables are being populated right.

When I get to this insert my plsql program just hangs.