using (var cmd = new OracleCommand())
                    {
                        cmd.CommandType = System.Data.CommandType.StoredProcedure;
                        cmd.Connection = connection;
                        cmd.CommandText = "DBMS_APPLICATION_INFO.SET_CLIENT_INFO";

                        cmd.Parameters.Add("client_info", OracleDbType.Varchar2, "MYVALUE123", System.Data.ParameterDirection.Input);

                        connection.Open();
                        cmd.ExecuteNonQuery();
                    }