• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
Bartenders:
  • Himai Minh
  • Carey Brown
  • Frits Walraven

calling a PL/SQL procedure from a Java application

 
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
ranger
Posts: 17346
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Author
Posts: 3450
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Look at Callable Statements if you want to use JDBC.
 
Mark Spritzler
ranger
Posts: 17346
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Well THAT's new! Comfort me, reliable tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic