This question should be asked on the Hibernate forum. No, you can't reverse engineer stored procedures into something else with the Hibernate Tools. There is nothing to "reverse engineer", what you are asking for would be a code translator from one procedural programming language (PL/SQL) into another procedural programming language (Java).
I know that Java does not (yet anyways) support multiple class inheritance like C++, but I wouldn't call Java "procedural". It's object-oriented.
In any event, I appreciate your reply, and I posted the question in the Hibernate/DB area. thx.