<%@LANGUAGE="VBSCRIPT"%> <% '===================================================== '| | '| OSDefault | '| | '===================================================== %> <% Option explicit Response.Expires = 0 %> <% '------------ VARIABLE DEFINITION ------------- Dim bom_version, bom_lifecycle,sbom Dim bom_id Dim os_id Dim pos, pos2, pos3, pos4 Dim rsQry, rsPD '------------ CONSTANTS DECLARATION ----------- '------------ VARIABLE INIT ------------------- sbom = Request("sbom") '------------ CONDITIONS ---------------------- '---------------------------------------------- %> Deployment Manager <% OraDatabase.Parameters.Add "NODE_NAME", Request("node"), ORAPARM_INPUT, ORATYPE_VARCHAR2 OraDatabase.Parameters.Add "PROJ_NAME", Request("project"), ORAPARM_INPUT, ORATYPE_VARCHAR2 OraDatabase.Parameters.Add "BRANCH_NAME", Request("release"), ORAPARM_INPUT, ORATYPE_VARCHAR2 OraDatabase.Parameters.Add "BOM_VERSION", Request("version"), ORAPARM_INPUT, ORATYPE_NUMBER OraDatabase.Parameters.Add "BOM_LIFECYCLE", Request("lifecycle"), ORAPARM_INPUT, ORATYPE_NUMBER OraDatabase.Parameters.Add "OS_NAME", Request("os"), ORAPARM_INPUT, ORATYPE_VARCHAR2 Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("patch_OsId.sql"), ORADYN_DEFAULT ) If rsQry.Recordcount > 0 Then %> <% Else Response.Write("No Patches Found For "&Request("node")&".") End If While (NOT rsQry.BOF) AND (NOT rsQry.EOF) OraDatabase.Parameters.Add "PV_ID", rsQry("pv_id"), ORAPARM_INPUT, ORATYPE_NUMBER Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT ) %> <% OraDatabase.Parameters.Remove "PV_ID" rsPD.Close() Set rsPD = nothing rsQry.MoveNext WEnd OraDatabase.Parameters.Remove "OS_NAME" OraDatabase.Parameters.Remove "BOM_LIFECYCLE" OraDatabase.Parameters.Remove "BOM_VERSION" OraDatabase.Parameters.Remove "RBANCH_NAME" OraDatabase.Parameters.Remove "PROJ_NAME" OraDatabase.Parameters.Remove "NODE_NAME" rsQry.Close() Set rsQry = nothing %>
Product
Package
Name
Version
Name
Version
<%=rsQry("pkg_name")%>
<%=rsQry("pkg_version")%>
<%=rsPD("pkg_name")%>
<%=rsPD("pkg_version")%>
<% '------------ RUN AFTER PAGE RENDER ----------- '---------------------------------------------- %>