iorder_id和oaddress的传递类型

现打算基于orders表创建名为findAddressByOrderID的存储过程，其参数为iorder_id和oaddress，功能是根据订单编号iorder_id 带回订单对应的地址oaddress。那么iorder_id和oaddress的传递类型可以是
哪个in哪个out啊

iorder_id是in，要把这个id传入byorderid存储过程里，oaddress是out，最后输出匹配参数。完整的code这样做：

Create procedure findAddressByOrderID
(
  IN iorder_id INT, 
  OUT oaddress VARCHAR(255)
)
BEGIN

SELECT address INTO oaddress FROM orders WHERE order_id = iorder_id;

END;