-- -- packages/bboard-portlets/sql/bboard-portlets-drop.sql -- -- Drops bboard datasources for portal portlets -- Copyright (C) 2001 ArsDigita Corporation -- @author Michael Bryzek (mbryzek@arsdigita.com) -- @creation-date 2001-02-26 -- $Id: bboard-portlets-drop.sql,v 1.1.1.1 2002/07/09 17:35:01 rmello Exp $ -- This is free software distributed under the terms of the GNU Public -- License. Full text of the license is available from the GNU Project: -- http://www.fsf.org/copyleft/gpl.html declare ds_id portal_datasources.datasource_id%TYPE; begin begin select datasource_id into ds_id from portal_datasources where name = 'Summarize bboard applications' and package_key = 'bboard'; exception when no_data_found then ds_id := null; end; if ds_id is not null then portal_datasource.delete(ds_id); end if; end; / show errors;