Problems with a trigger

From: Andrea Pallotta <anpallotta_at_flashnet.it>
Date: 1997/03/12
Message-ID: <01bc2f3a$078e34a0$48a1f7c2@rm03772>#1/1

Hi there!!!

I have this problem with a trigger.
The trigger i've wrote should fill a table (called "two") with a sorted list based on another table (called "one" ). The list in "two" will be recreated every time a new row is inserted in the first table "one".
It works fine... but only with few rows ( 100-150 ) if i test the trigger with a loop like this, the rows in "two" are not sorted ...

Some suggest to solve this problem??

This is the trigger
declare

	cursor rows is
		select * from one order by 1,2,3;
	row rows%rowtype;

begin

for row in rows loop

        insert into two values (a,b,c,d);
end loop;

this is the test loop.
begin

for i in 1..1000

        insert into one values (a,b,c,d);
end loop;

Thanks in advance

Andrea Pallotta
Gruppo di Sviluppo
Digital Italia Received on Wed Mar 12 1997 - 00:00:00 CST