Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Java in General and the fly likes Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » Java in General
Reply Bookmark "Stored Procedure" Watch "Stored Procedure" New topic
Author

Stored Procedure

Syed Basha
Greenhorn

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

Joined: Mar 17, 2000
Posts: 5782
posted private message
0
Quote
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
Sheriff

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