procedure settings_get
(
	p_name settings.name%type,
	p_value out clob
)
is
begin
	select
		value
	into
		p_value
	from
		settings
	where
		name = p_name;
end;

OracleParameter p_value = new OracleParameter("p_value", OracleType.Clob);
p_value.Direction = ParameterDirection.Output;
command.Parameters.Add(p_value);

try
{
	connection.Open();
	command.ExecuteNonQuery();
	OracleLob lob = (OracleLob) p_value.Value;

	result = (string) p_value.Value;
}
finally
{
	connection.Close();
}

try
{
	connection.Open();
	command.ExecuteNonQuery();
	OracleLob lob = (OracleLob) p_value.Value;

	result = (string) lob.Value;
}
finally
{
	connection.Close();
}