File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Calling Stored Procedure from JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Calling Stored Procedure from JSP" Watch "Calling Stored Procedure from JSP" New topic

Calling Stored Procedure from JSP

Alan Dong

Joined: Dec 31, 2003
Posts: 1
Anyone could give me an simple example on how to calling a stored procedure(in oracle DB) from JAP?
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32818

Sun's JDBC tutorial is a good place to start. You will need to read about callable statements.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63540

Moving to the JDBC forum.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: Calling Stored Procedure from JSP
It's not a secret anymore!