Hi,

We are using springjdbccall to execute stored procedures in oracle database. I was reusing the same springjdbccall to call multiple stored procedures. For example:

stored proc 1 - createCustomer
parameter - customer_type (oracle type)

stored proc 2 - loadCustomer
parameter - id (number)

The issue we were facing is, when executing the second stored procedure (load_customer), the simplejdbccall was still holding on to the parameter (customer_type) from the first stored proc call (load_customer). So we would get an exception saying in or out parameter missing on the second stored proc call.

I want to know how to clear the parameters before making a call to another stored procedure.

I worked around this by instantiating a new simplejdbccall for every stored proc call. But this is costly.

Please let me know your suggestions.

Thanks,
HariKrishnan