-- packages/curriculum/sql/oracle/curriculum-element-drop.sql
--
-- @author Ola Hansson (ola@polyxena.net)
-- @creation-date 2003-05-23
-- @cvs-id $Id: curriculum-element-drop.sql,v 1.1 2003/05/26 17:40:02 olah Exp $

drop view cu_elements_enabled;
drop table cu_elements;

-- Had to add this in order to cleanly drop the package when
-- there were elements created in the db.
delete from acs_objects where object_type = 'cu_element';

declare
begin
    acs_object_type.drop_type (
        object_type => 'cu_element'
    );
end;
/
show errors