springjdbccall parameter caching
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
