title: "Boolean" parameter for Oracle stored procedure
body: <p>I'm aware that Oracle does not have a boolean type to use for parameters, and am currently taking in a NUMBER type which would have 1/0 for True/False (instead of the 'Y'/'N' CHAR(1) approach).</p>
  
  <p>I'm not a very advanced Oracle programmer, but after doing some digging and reading some ASKTOM posts, it seems like you can restrict a field using a format for the column like:</p>
  
  <p><code>MyBool NUMBER(1) CHECK (MyBool IN (0,1))</code></p>
  
  <p>Is there a way to apply the same sort of a check constraint to an input parameter to a stored procedure?  I'd like to restrict the possible inputs to 0 or 1, rather than checking for it explicitly after receiving the input.</p>