Subversion Repositories DevTools

Rev

Rev 5513 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5513 Rev 5955
Line 65... Line 65...
65 
%>
65 
%>
66 
 
 66 
 
67 
 
 67 
 
68 
<%
 68 
<%
69 
	While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 69 
	While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
70 
	OraDatabase.Parameters.Add "PV_ID", 	rsQry("pv_id"),		ORAPARM_INPUT, ORATYPE_NUMBER
70 
	    OraDatabase.Parameters.Add "PV_ID", 	rsQry("pv_id"),		ORAPARM_INPUT, ORATYPE_NUMBER
71 
	Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT )
71 
	    Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT )
72
72
73 
%>
73 
%>
74 
 
 74 
 
75 
<%=rsQry("pkg_name")%><%=Chr(9)%>
 75 
<%=rsQry("pkg_name")%><%=Chr(9)%>
76 
<%=rsQry("pkg_version")%><%=Chr(9)%>
 76 
<%=rsQry("pkg_version")%><%=Chr(9)%>
Line 78... Line 78...
78 
<%=rsPD("pkg_version")%><%=Chr(9)%>
 78 
<%=rsPD("pkg_version")%><%=Chr(9)%>
79 
<%=newline%>
 79 
<%=newline%>
80 
 
 80 
 
81 
 
 81 
 
82 
<%
82 
<%
83 
 
 - 
 
84
- 
 
85 
	OraDatabase.Parameters.Remove "PV_ID"
83 
	    OraDatabase.Parameters.Remove "PV_ID"
86 
		rsPD.Close()
 84 
		rsPD.Close()
87 
		Set rsPD = nothing
 85 
		Set rsPD = nothing
88 
		rsQry.MoveNext
86 
		rsQry.MoveNext
89 
		WEnd
87 
	WEnd
90 
	OraDatabase.Parameters.Remove "OS_NAME"
88 
	OraDatabase.Parameters.Remove "OS_NAME"
91 
	OraDatabase.Parameters.Remove "BOM_LIFECYCLE"
89 
	OraDatabase.Parameters.Remove "BOM_LIFECYCLE"
92 
	OraDatabase.Parameters.Remove "BOM_VERSION"
90 
	OraDatabase.Parameters.Remove "BOM_VERSION"
93 
	OraDatabase.Parameters.Remove "RBANCH_NAME"
91 
	OraDatabase.Parameters.Remove "BRANCH_NAME"
94 
	OraDatabase.Parameters.Remove "PROJ_NAME"
92 
	OraDatabase.Parameters.Remove "PROJ_NAME"
95 
	OraDatabase.Parameters.Remove "NODE_NAME"
93 
	OraDatabase.Parameters.Remove "NODE_NAME"
96
94
97 
		rsQry.Close()
 95 
		rsQry.Close()
98 
		Set rsQry = nothing
 96 
		Set rsQry = nothing