my dog learned polymorphism*
The moose likes Java in General and the fly likes Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Stored Procedure" Watch "Stored Procedure" New topic

Stored Procedure

Syed Basha

Joined: Sep 21, 2001
Posts: 18
Can we use Stored Procedure in 3 tier architecture, if not why?
Ajith Kallambella

Joined: Mar 17, 2000
Posts: 5782
Sure you can! Instead of having embeded SQLs in the code, you can call a procedure to do the job.

Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
Ajith Kallambella

Joined: Mar 17, 2000
Posts: 5782
I'm moving this discussion to Java in general(intermediate) forum.
I agree. Here's the link:
subject: Stored Procedure
Similar Threads
query for updating
stored procedure inside another stored procedure
Passing array to CallableStatement
How to get a return value from the stored procedure using callable statement
Help with: java.sql.SQLException: ORA-01008: not all variables bound