oracle编码储存过程,从Oracle存储过程获取值

我有一个Oracle过程,它将返回所有参数的串联字符串

create or replace procedure tin_builder (type in varchar2,

tin_serial in number, rand_digit in varchar2, tin out varchar2 ) is

BEGIN

tin := type || TO_CHAR(tin_serial) || rand_digit ;

END

现在,我想从Visual Studio 2008调用该过程(C代码)

public void TinBuilder(string type, long tin_serial, string rand_digit)

{

OracleConnection connection = new OracleConnection("Data Source=xe;User ID=system;Password=******;");

OracleCommand cmd = new OracleCommand();

cmd.Connection = connection;

cmd.CommandText = "tin_builder";

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("type", OracleDbType.Varchar2).Value = type;

cmd.Parameters.Add("tin_serial", OracleDbType.Decimal).Value = tin_serial;

cmd.Parameters.Add("rand_digit", OracleDbType.Varchar2).Value = rand_digit;

cmd.Parameters.Add("tin", OracleDbType.Varchar2).Direction = ParameterDirection.ReturnValue;

try

{

connection.Open();

cmd.ExecuteNonQuery();

TextBox1.Text = cmd.Parameters["tin"].Value.ToString();

}

catch (Exception ex)

{

}

finally

{

connection.Close();

}

}

然后用:

TinBuilder("1", 10000001, "37");

但它不在文本框中显示任何值:(。请有人帮帮我。