Martin Vajsar wrote:You had three question marks, two input parameters and one output parameter (all properly registered), so that would look about right. Adding another one is certainly not going to help.
You've posted a wrong stored procedure - GET_CONTACT_REQUEST_BY_SSN, but your code calls GET_CONTACT. Posting the right one might give us a better clue. I guess (just guess) that the third parameter is an IN OUT one, not just OUT one. It might mean that you need to set the third parameter and register it as an output one at the same time.
OK, that makes sense. Thank you. The stored procedure is what the DBA gave me to call. I will try the changes that you are suggesting. This site have amazingly fast responses to programming questions. I have been on sites that it may take days or weeks before someone will reply. I think I have found a coding message board that I can stick around with. Thanks again for the responses.