Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

calling a PL/SQL procedure from a Java application

 
mara thamizhan
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
With which Java Technology do you want to use to call it.

JDBC
iBatis
An Orm tool like TopLink or Hibernate?

Mark
 
arulk pillai
Author
Ranch Hand
Posts: 3387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Look at Callable Statements if you want to use JDBC.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by arulk pillai:
Look at Callable Statements if you want to use JDBC.


Actually if you want to use JDBC, look at Spring's SimpleJdbcTemplate to save a lot of extra coding.

Anyway, we need to find out which tech you want to use, because if it is JDBC, then this is the wrong forum for the question.

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic