rem
rem This script can be used to delete a Warehouse Object.
rem
rem USAGE
rem Logon as WorkspaceOwner or WorkspaceUser with Admin privilege
rem    
rem    @<OWB-HOME>/owb/rtp/sql/delete_warehouse_object.sql <object-name> <location-name> <workspace>
rem
rem This script deletes the object with the given name from the given location.
rem
rem The given workspace is the one in which the object was deployed
rem <workspace> should be declared as workspaceOwner.workspaceName
rem if only workspaceName is given, workspaceOwner will be defaulted to user
rem

set serveroutput on;

set echo off
set verify off

define OBJECT = &1.
define STORE = &2.
define WORKSPACE = &3.

set role OWB_USER;
call owbsys.wb_rt_script_util.set_workspace('&WORKSPACE.');

declare
begin
  owbsys.wb_rt_script_util.delete_warehouse_object('&OBJECT.','&STORE.');
  
end;
/