Getting not all entry's in table

From: Rob Zwartjes <rzwartje_at_rob.home.nl>
Date: 24 Feb 2001 19:50:16 GMT
Message-ID: <slrn99g4lq.d2h.rzwartje@rob.home.nl>

Hello there,

I have a problem with retrieving all the information in a table running a script.
Here is what I do in short from:

procedure fill_table is
begin

	insert into my_table values(......);
	commit;

end fill_table;

procedure check_table is

	cursor c1 is
		select my_name from my_table;

	k number(3) := 0;
	name is table of varchar2(30) index by binary_integer;
begin
	if not c1%isopen then
		open c1;
	end if;
	loop
		fetch c1 into name(k);
		exit when c1%notfound;
		k := k + 1;
	end loop;
	k := k _ 1;

end check_table;

First procedure fill_table fills my table with some data. At the end I want to check table my_table with procedure check_table. The problem now is that check_table only returns the new enterd entry's and not the one I made in a previous run. I put the command "commit" in it to finish the insert but that doesn't help.
What am I forgetting ????

Thanks in advance,
Rob Received on Sat Feb 24 2001 - 13:50:16 CST