Subversion Repositories DevTools

Rev

Blame | Last modification | View Log | RSS feed

<%
'=====================================================
'                                       CONFIG FILE
'=====================================================
%>
<%
' -- VARIABLE DEFINITION ------------------------------
Dim OraSession, OraDatabase             ' DB connection
Dim QUERIES_PATH
Dim SCRIPT_NAME
Dim APP_ROOT
' -----------------------------------------------------
%>
<%
' -- DATABASE CONNECTIONS -----------------------------
'Set OraSession = CreateObject("OracleInProcServer.XOraSession")
'OraSession.CreateDatabasePool 1,10,100, Application("TNS_NAME"), Application("ACCESS_MANAGER_LOGIN"), 0 
'Set OraDatabase = OraSession.GetDatabaseFromPool(10)

Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase( Application("TNS_NAME"), Application("ACCESS_MANAGER_LOGIN"), Cint(0))

' -----------------------------------------------------
%>
<%
' -- CONFIGURATIONS -----------------------------------
APP_ROOT = Server.MapPath(".")
Const APPLICATION_ID = 9                        ' Stored in Access Manager, [APPLICATIONS] table
QUERIES_PATH = APP_ROOT &"\queries"
Const ADMIN_EMAIL = "svukovic@erggroup.com"
' -----------------------------------------------------
%>
<%
' -- VARIABLE INITIALISATION --------------------------
SCRIPT_NAME = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
' -----------------------------------------------------
%>
<%
' -- CONSTANTS ----------------------------------------
Const enumDB_DEFAULT_EMPTY = -1
Const enumDB_YES = "Y"
Const enumDB_NO = "N"
Const enumCOOKIE_NAME = "ACCESS_MANAGER"
Const SPACER = "<img src='images/spacer.gif' width='1' height='1'>"
' -----------------------------------------------------
%>
<%
' -- OO4O ---------------------------------------------
const ORATYPE_VARCHAR2 = 1
const ORATYPE_NUMBER = 2
const ORATYPE_SINT = 3
const ORATYPE_FLOAT = 4
const ORATYPE_STRING = 5
const ORATYPE_VARCHAR = 9
const ORATYPE_DATE = 12
const ORATYPE_UINT = 68
const ORATYPE_RAW = 95
const ORATYPE_CHAR = 96
const ORATYPE_CHARZ = 97
const ORATYPE_MLSLABEL = 105
const ORATYPE_OBJECT = 108
const ORATYPE_REF = 110
const ORATYPE_CLOB = 112
const ORATYPE_BLOB = 113
const ORATYPE_BFILE = 114
const ORATYPE_VARRAY = 247
const ORATYPE_TABLE = 248

const ORAPARM_INPUT=1   
const ORAPARM_OUTPUT=2  
const ORAPARM_BOTH=3

const ORADYN_DEFAULT=&H0&
' -----------------------------------------------------
%>
<%
' -- ERROR MESSAGES -----------------------------------
' -----------------------------------------------------
%>
<%
' -- ICONS --------------------------------------------
' -- ICONS SMALL --------------------------------------
' -----------------------------------------------------
%>