调用vb.net中包中的Oracle函数

Dim connectionString As String = "Data Source=your_oracle_server;User Id=your_username;Password=your_password;"
Dim connection As New OracleConnection(connectionString)
connection.Open()

Dim command As New OracleCommand()
command.Connection = connection
command.CommandText = "your_function_name"
command.CommandType = CommandType.StoredProcedure

Dim inputParam As New OracleParameter()
inputParam.ParameterName = "input_param_name"
inputParam.OracleDbType = OracleDbType.Varchar2
inputParam.Value = "input_value"
command.Parameters.Add(inputParam)

Dim outputParam As New OracleParameter()
outputParam.ParameterName = "output_param_name"
outputParam.OracleDbType = OracleDbType.Varchar2
outputParam.Direction = ParameterDirection.Output
command.Parameters.Add(outputParam)

command.ExecuteNonQuery()
Dim result As String = command.Parameters("output_param_name").Value.ToString()

connection.Close()