170: BEGIN
171: -- Install MV and MVQ
172: IF (ab_long_stmt_i)
173: THEN
174: ad_zd_mview.INSTALL_MVQ_ARCH(ga_c_stmt);
175: ELSE
176: ad_zd_mview.INSTALL_MVQ_ARCH(as_stmt_i);
177: END IF;
178:
172: IF (ab_long_stmt_i)
173: THEN
174: ad_zd_mview.INSTALL_MVQ_ARCH(ga_c_stmt);
175: ELSE
176: ad_zd_mview.INSTALL_MVQ_ARCH(as_stmt_i);
177: END IF;
178:
179: ga_c_stmt := '';
180: EXCEPTION
278: exception when e_mv_nofound
279: then
280: if g_edition_enabled = 'Y'
281: then
282: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);
283: end if;
284: raise;
285: end;
286:
285: end;
286:
287: if g_edition_enabled = 'Y'
288: then
289: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);
290: end if;
291: END drop_mv;
292:
293: --
340: exception when e_mv_nofound
341: then
342: if g_edition_enabled = 'Y'
343: then
344: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);
345: end if;
346: raise;
347: end;
348: if g_edition_enabled = 'Y'
346: raise;
347: end;
348: if g_edition_enabled = 'Y'
349: then
350: ad_zd_mview.drop_mvq(p_mvname=>as_mview_name_i);
351: end if;
352: end;
353: ELSIF (an_operation_i = ad_mv.mv_alter)
354: THEN