File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
How to get a return value from the stored procedure using callable statement
query for updating
stored procedure inside another stored procedure
Passing array to CallableStatement
Help with: java.sql.SQLException: ORA-01008: not all variables bound