// Вызов процедуры Test3() c возвратом двух параметров (типа varchar2 и number)
//  -------------------------------------------------- 
// procedure test3(arg1 out varchar2,arg2 out number);
//  -------------------------------------------------- 
public static void GoTEST3(OracleConnection Conn)
{
	OracleCommand Comm=new OracleCommand("test.test3",Conn);
	Comm.CommandType=CommandType.StoredProcedure;		

	Comm.Parameters.Add(new OracleParameter("arg1",OracleType.VarChar, 255 ,ParameterDirection.Output,true, 0 , 0 ,"",DataRowVersion.Current,""));
	Comm.Parameters.Add(new OracleParameter("arg2",OracleType.Number, 38 ,ParameterDirection.Output,true, 0 , 0 ,"",DataRowVersion.Current, 0 ));			

	Console.WriteLine(Comm.CommandText);
	int res=Comm.ExecuteNonQuery();			
	Console.WriteLine("---------- Return parameters: ---------------------");
	IEnumerator Ie=Comm.Parameters.GetEnumerator();
	while(Ie.MoveNext())
	{
		Console.WriteLine("ParameterName = {0}",((OracleParameter)Ie.Current).ParameterName);
		Console.WriteLine("Value = {0}",((OracleParameter)Ie.Current).Value);
		Console.WriteLine("DbType = {0}",((OracleParameter)Ie.Current).DbType);
		Console.WriteLine("OracleType = {0}",((OracleParameter)Ie.Current).OracleType);
		Console.WriteLine("Direction = {0}",((OracleParameter)Ie.Current).Direction);			
		Console.WriteLine("Precision = {0}",((OracleParameter)Ie.Current).Precision);
		Console.WriteLine("Scale = {0}",((OracleParameter)Ie.Current).Scale);
		Console.WriteLine("Offset = {0}",((OracleParameter)Ie.Current).Offset);
		Console.WriteLine("Size = {0}",((OracleParameter)Ie.Current).Size);
		Console.WriteLine("SourceColumn = {0}",((OracleParameter)Ie.Current).SourceColumn);
		Console.WriteLine("SourceVersion = {0}",((OracleParameter)Ie.Current).SourceVersion);
		Console.WriteLine("");				
	}
	Console.WriteLine("---------------------------------------------------");
	Console.WriteLine("res = {0}",res);
}		

Console.WriteLine("arg1.ParameterName = {0}",Comm.Parameters["arg1"].ParameterName);
Console.WriteLine("arg1.Value = {0}",Comm.Parameters["arg1"].Value);
Console.WriteLine("arg1.DbType = {0}",Comm.Parameters["arg1"].DbType);
Console.WriteLine("arg1.OracleType = {0}",Comm.Parameters["arg1"].OracleType);
Console.WriteLine("arg1.Direction = {0}",Comm.Parameters["arg1"].Direction);			
Console.WriteLine("res = {0}",res);