Subversion Repositories DevTools

Rev

Rev 62 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
62 rsolanki 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|			          _SetBaseConf				 	 |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
Response.Expires = 0
12
%>
13
<!--#include file="common/globals.asp"-->
14
<!--#include file="common/config.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="common/_code_behind_common.asp"-->
17
<%
18
'------------ ACCESS CONTROL ------------------
19
%>
20
<!--#include file="_access_control_general.asp"-->
21
<%
22
'------------ VARIABLE DEFINITION -------------
23
'------------ CONSTANTS DECLARATION -----------
24
'------------ VARIABLE INIT -------------------
25
'------------ CONDITIONS ----------------------
26
'----------------------------------------------
27
%>
28
<%
29
'--------------------------------------------------------------------------------------------------------------------------
30
Sub SetBaseConf ()
31
	On Error Resume Next
32
 
33
	OraDatabase.Parameters.Add "OS_ID", 		Request("os_id"), 		ORAPARM_INPUT, ORATYPE_NUMBER 
34
	OraDatabase.Parameters.Add "BASE_ENV_ID", 	Request("base_env_id"), ORAPARM_INPUT, ORATYPE_NUMBER 
35
 
36
 
37
	objEH.TryORA ( OraSession )
38
 
39
	OraDatabase.ExecuteSQL _
40
	"BEGIN   pk_Operating_System.Set_Base_Conf ( :OS_ID, :BASE_ENV_ID);   END;"
41
 
42
	objEH.CatchORA ( OraSession )
43
 
44
	OraDatabase.Parameters.Remove "OS_ID"
45
	OraDatabase.Parameters.Remove "BASE_ENV_ID"
46
 
47
End Sub
48
'--------------------------------------------------------------------------------------------------------------------------
49
%>
50
<%
51
'**************************** M  A  I  N ******************************
52
If (Request("action") <> "") Then
53
	' --- Form is Valid ---
54
	Call SetBaseConf()
55
 
56
	If objEH.Finally Then
57
		Call OpenInWindow ( Request("rfile") &"?SET=OK"& objPMod.ComposeURLWithout("rfile") )
58
	End If
59
 
60
End If
61
'**********************************************************************
62
%>
63
<%
64
'------------ RUN AFTER CODE RUN --------------
65
'----------------------------------------------
66
%><!--#include file="common/globals_destructor.asp"-->