Not near enough information to help.

What does the signature of the stored procedure form Oracle look like?

storedproc_name

@param1 <datatype>,

@param2 <datatype>

If the stored procedure already has paramters, are you trying to use value lists to limit the values being passed back to the stored procedure?