<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|
'|  _DeleteBaseView.asp
'|
'=====================================================
%>
<%
Option explicit
Response.Expires = 0
%>
<!--#include file="common/conf.asp"-->
<!--#include file="common/globals.asp"-->
<!--#include file="common/formating.asp"-->
<!--#include file="common/qstr.asp"-->
<!--#include file="common/common_subs.asp"-->
<!--#include file="common/_form_window_common.asp"-->
<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_general.asp"-->
<!--#include file="_access_control_login.asp"-->
<%
'------------ VARIABLE DEFINITION -------------
'------------ CONSTANTS DECLARATION -----------
'------------ VARIABLE INIT -------------------
'------------ CONDITIONS ----------------------
'----------------------------------------------
%>
<%
'--------------------------------------------------------------------------------------------------------------------------
Sub DeleteBaseView (view_id)
	On Error Resume Next
	OraDatabase.Parameters.Add "VIEW_ID",	view_id,	ORAPARM_INPUT, ORATYPE_NUMBER 
	objEH.TryORA ( OraSession )
	OraDatabase.ExecuteSQL "BEGIN DELETE FROM VIEWS WHERE VIEW_ID = :VIEW_ID; END;"
	objEH.CatchORA ( OraSession )	
	OraDatabase.Parameters.Remove "VIEW_ID"
End Sub
'--------------------------------------------------------------------------------------------------------------------------
%>
<%
'**************************** M  A  I  N ******************************
' --- Form is Valid ---
Call DeleteBaseView(Request("view_id"))

If objEH.Finally Then
	Call OpenInWindow ("admin_baseviews.asp")
End If
'**********************************************************************
%>
<%
'------------ RUN AFTER CODE RUN --------------
'----------------------------------------------
'----------------------------------------------
Call Destroy_All_Objects
%>