Database

<br />
PROCEDURE validate_master_account_id (v_master_account_id IN NUMBER, v_is_valid OUT NUMBER);      <br />

<br />
public static bool TestProcedure()<br />
{<br />
	  string procedureName = "SMT.CPR_MASTER_ACCOUNT_PKG.validate_master_account_id";<br />
	  using (OracleConnection connection = new OracleConnection(AppSettings.ConnectionString))<br />
	  {<br />
		    connection.Open();<br />
<br />
		    using (OracleCommand command = new OracleCommand(procedureName, connection))<br />
		    {<br />
			      command.Parameters.Add("v_master_account_id", OracleType.Number).Value = 16793;<br />
			      command.Parameters.Add("v_is_valid", OracleType.Number).Direction = ParameterDirection.Output;<br />
<br />
			      command.ExecuteNonQuery();<br />
			      bool result = ((int) command.Parameters["v_is_valid"].Value) == 1;<br />
			      return result;<br />
		    }<br />
	  }<br />
}<br />