调用存储过程示例

create or replace procedure "SYSDBA"."PROC_TEST" (c1 char, c2 out varchar)
AS
BEGIN
	select col2 into c2 from mytable where col1 = c1;
END;

string connStr = "DSN=XuguDB;USER=SYSDBA;PWD=SYSDBA;";
OdbcConnection conn = new OdbcConnection(connStr);
conn.Open();
OdbcCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "execute PROC_TEST(?,?)";

OdbcParameter[] parameters = { new OdbcParameter("c1", OdbcType.Char, 30), new OdbcParameter("c2", OdbcType.VarChar, 50) };

parameters[0].Value = "XuguDB";
parameters[1].Direction = ParameterDirection.Output;

cmd.Parameters.Add(parameters[0]);
cmd.Parameters.Add(parameters[1]);

cmd.ExecuteNonQuery();

Console.WriteLine((string)parameters[1].Value);

conn.Close();