A list of parameters for any stored procedure, which must be useful for buddies who want to do a fully loose coupling system. This program gains a list of parameters for stored procedures of '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 "