获得任意一个存储过程的参数列表,这个对于想做完全松耦合系统的哥们一定有用的。这个程序获得名字为'PRO_HOUSE_ADD_INFO'的存储过程的参数列表
connstr = "Provider=MSDAORA.1;User ID=liujincai;password=ljc1001;Data Source=hp1"
set mm=server.CreateObject("adodb.connection")
mm.Open connstr
Const adSchemaProcedureParameters = 26
set rs=mm.OpenSchema(adSchemaProcedureParameters) rs.Filter="PROCEDURE_NAME='PRO_HOUSE_ADD_INFO'"? Response.Write " < TABLE cellSpacing=0 border=1>"
Response.Write " < TBODY> < TR bgColor=#dddddd>"
for i=2 to rs.fields.count-1
Response.Write " < TD>" & rs(i).name & "< /TD>"
next
Response.Write "< /TR>"
do while not rs.eof
Response.Write " < TR bgColor=#e0d0c0>"
for i=2 to rs.fields.count-1
Response.Write " < TD>" & rs(i) & "< /TD>"
next
Response.Write "< / tr >“
rs.movenext
loop
Response.Write "《/ table >”