Josue
Sorry, I didn't realize that the actual problem was with a stored procedure, I thought it was with the
java that called it. I am not a stored procedure expert so can't help you.
You might want to post the relevant sections here so someone else can check them out.