Drop inside a cursor in Oracle

I have a database with many user defined types. Sometimes I want to drop them all, without the tedious work of dropping in the correct order. So I figured a stored procedure with a cursor could do the job for me.

I declared a cursor which selects type_name from user_types and tries to drop the type inside the cursor loop. The compiler complains about unexpected drop statement.

My code:
create or replace procedure drop_all_types is

	curr_type varchar2(100);
	cursor finn_typer is
		select type_name from user_types;

	begin
		open finn_typer;
		loop
			fetch finn_typer into curr_type;
			exit when finn_typer%notfound;
                       drop type curr_type force; -- this is where my
compiler complains
		end loop;
                close finn_typer;
	end;

How do I fix this? I've done this before, many years ago... but have forgotten how.
Anyone care to guide me, please? Received on Sat Nov 24 2007 - 11:58:59 CST