calling a PL/SQL procedure from a Java application

[mara thamizhan]

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:

 
 
SET SERVER OUTPUT ON
CREATE OR REPLACE PROCEDURE get_employeename
DECLARE
v_emp_name varchar2(25)
BEGIN
select last_name
into v_emp_name
from employees
where employee_id=176;
if(v_emp_name='Taylor') then
DBMS_OUTPUT.PUT_LINE('The employee's name is '||to_char(v_emp_name));
else
DBMS_OUTPUT.PUT_LINE('The employee's name is not Taylor');
END IF;
END;
/
 
   

When I execute this procedure through isql*plus i get the output

 
 
The employee's name is Taylor   

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]

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

JDBC
iBatis
An Orm tool like TopLink or Hibernate?

Mark

[arulk pillai]

Look at Callable Statements if you want to use JDBC.

[Mark Spritzler]

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