Parameter <str> is referenced as an IN parameter, but declared
  as OUT

  Explanation:  The parameter named in the message was declared
  with an explicit parameter mode, but its usage conflicts with
  the declaration.

  User Action:  Make the parameter INOUT or change the usage in
  the procedure.