Dear all, I used to refer this post frequently to update my knowledge regarding ORM technologies & to troubleshoot problems. Thanks for all of you in this. Now i've been going through PL/SQL procedures for quite some time. As I perceive the main benefit of PL/SQL procedures is that it improves the performance of the application & also 1) we can do iterative loop process ( for ...) on the procedural query statements. 2) we can iterate over a collection of rows (retrieved from SQL statements) through a cursor. 3) we can check for conditional statements. Now consider i've a PL/SQL procedure called from a iSQL*plus environment like this:
When I execute this procedure through isql*plus i get the output
Can anyone explain how to call this PL/SQL procedure through a J2EE application or atleast provide some good links where i can find one.