1491: PROCEDURE dropMview( pMode IN Varchar2, pOwner IN Varchar2,pName IN Varchar2) IS
1492:
1493: CURSOR dr_obj_mv(pOwner IN Varchar2,pName IN Varchar2) is
1494: Select 'drop materialized view '||owner||'.'||mview_name sqlstmt 1495: From all_mviews 1496: Where owner = pOwner
1497: And mview_name = pName;
1498: ddl_curs integer;
1499: Begin