Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 5952
Line 136... Line 136...
136 
	End If
 136 
	End If
137
137
138
138
139 
	OraDatabase.Parameters.Add "COMPARE_PV_ID", parComparePvId,	ORAPARM_INPUT, ORATYPE_NUMBER
139 
	OraDatabase.Parameters.Add "COMPARE_PV_ID", parComparePvId,	ORAPARM_INPUT, ORATYPE_NUMBER
140 
	OraDatabase.Parameters.Add "PKG_ID", 		pkgInfoHash.Item("pkg_id"),	ORAPARM_INPUT, ORATYPE_NUMBER
140 
	OraDatabase.Parameters.Add "PKG_ID", 		pkgInfoHash.Item("pkg_id"),	ORAPARM_INPUT, ORATYPE_NUMBER
141
- 
 
142 
	If IsNull(pkgInfoHash.Item("v_ext")) OR (pkgInfoHash.Item("v_ext") = "") Then
 - 
 
143 
		OraDatabase.Parameters.Add "V_EXT", 		NULL,	ORAPARM_INPUT, ORATYPE_VARCHAR2
- 
 
144 
	Else
 - 
 
145 
		OraDatabase.Parameters.Add "V_EXT", 		pkgInfoHash.Item("v_ext"),	ORAPARM_INPUT, ORATYPE_VARCHAR2
141 
	OraDatabase.Parameters.Add "V_EXT", 		EmptyToNull(pkgInfoHash.Item("v_ext")),	ORAPARM_INPUT, ORATYPE_VARCHAR2
146 
	End If
 - 
 
147
- 
 
148
142
149 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("AllPackageVersions.sql"), cint(0))
 143 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("AllPackageVersions.sql"), cint(0))
150
144
151 
	Response.write "<option value=''></option>"
 145 
	Response.write "<option value=''></option>"
152
146