PUBLIC void testFunction()
        {
            string s = "";

            var cmd = NEW OracleCommand()
            {
                Connection = conn,
                CommandText = "test_func",
                CommandType = CommandType.StoredProcedure,
                BindByName = TRUE

            };

            cmd.Parameters.Add("par1", OracleDbType.Int32, ParameterDirection.Input).VALUE = 123;
            cmd.Parameters.Add("par2", OracleDbType.Int32, ParameterDirection.Input).VALUE = 1;
            cmd.Parameters.Add("par3", OracleDbType.CHAR).Direction = ParameterDirection.Output;

            try
            {
                conn.OPEN();
                cmd.ExecuteNonQuery();
                s = cmd.Parameters["par1"].VALUE.ToString();
                s += cmd.Parameters["par2"].VALUE.ToString();
                s += cmd.Parameters["par3"].VALUE.ToString();
            }
            finally
            {
                conn.CLOSE();
            }

            Console.WriteLine(s);
        }