方法一
C#代码
private void button1_Click(object sender, EventArgs e)
{
using (OracleConnection conn=new OracleConnection(connstr))
{
if (conn.State== ConnectionState.Closed)
{
conn.Open();
}
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Test_Get_ID_pro";
cmd.Parameters.Add("user_name", OracleDbType.Varchar2).Value = "