File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes calling a PL/SQL procedure from a Java application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "calling a PL/SQL procedure from a Java application" Watch "calling a PL/SQL procedure from a Java application" New topic
Author

calling a PL/SQL procedure from a Java application

mara thamizhan
Ranch Hand

Joined: Jul 05, 2006
Posts: 74
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

Joined: Feb 05, 2001
Posts: 17249
    
    6

With which Java Technology do you want to use to call it.

JDBC
iBatis
An Orm tool like TopLink or Hibernate?

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
arulk pillai
Author
Ranch Hand

Joined: May 31, 2007
Posts: 3216
Look at Callable Statements if you want to use JDBC.


Java Interview Questions and Answers Blog | Amazon.com profile | Java Interview Books
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: calling a PL/SQL procedure from a Java application
 
Similar Threads
Is it possible to have a store procedre that has PL/SQL code and can call a java obje
Is it possible to have a store procedre that has PL/SQL code and can call a java obje
PL SQL cursor is throwing error...any idea?
SQL injection?
Nuber of records affected