<%@LANGUAGE="VBSCRIPT"%> <%Option Explicit%> <%Response.Expires = 0%> <% '-- VARIABLE DECLARATION ---------------- Dim tempArr Dim parRtag_id Dim missingPrereq Dim rsNotOfficial '-- CONSTANTS --------------------------- '-- INITIALISATION ---------------------- tempArr = Split( Session(enum_RELMGR_ERRDESCRIPTION), "|" ) parRtag_id = tempArr(0) missingPrereq = tempArr(1) '-- DESTROY ----------------------------- Session(enum_RELMGR_ERRDESCRIPTION) = NULL '---------------------------------------- %> <% Sub Not_Made_Official( NNmissingPrereqList, OOrs ) Dim Query_String Query_String = _ " SELECT pkg.pkg_name, pv.pkg_version"&_ " FROM packages pkg,"&_ " package_versions pv"&_ " WHERE pv.pkg_id = pkg.pkg_id"&_ " AND pv.pv_id IN ( "& NNmissingPrereqList &" )"&_ " ORDER BY UPPER(pkg.pkg_name)" Set OOrs = OraDatabase.DbCreateDynaset( Query_String, cint(0)) End Sub %>

Some Packages Not Released!   Following packages may be missing Label, Source Path, Reason for release or Fixed Issues List. <%Call Not_Made_Official( missingPrereq, rsNotOfficial )%> <%While ((NOT rsNotOfficial.BOF) AND (NOT rsNotOfficial.EOF))%> <%rsNotOfficial.MoveNext Wend%> <%=rsNotOfficial("pkg_name")%>  <%=rsNotOfficial("pkg_version")%>   Please, go to Release Notes tab for each package listed above and fix this problem.