Dim readCommand As New OracleCommand
Dim sqlconn As New OracleConnection(STRCONN)
sqlconn.Open()
readCommand.Connection = sqlconn
readCommand.CommandText = "P_CNT_CONTAB_FV_TESTATA" ' ---- nome procedura -----
readCommand.CommandType = CommandType.StoredProcedure
'attraverso il commandbuilder recupero i parametri
Dim builder As New OracleCommandBuilder
builder.DeriveParameters(readCommand)
'ciclo sulla collezione dei parametri
Dim Par As OracleParameter
For Each Par In readCommand.Parameters
Response.Write(Par.ParameterName + " " + Par.DbType.ToString() + " " + Par.Direction.ToString() + "<br>")
Next
sqlconn.Close()
posted @ giovedì 11 novembre 2004 14:48