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 Oracle Stored Procedures --- URGENT!!!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle Stored Procedures --- URGENT!!!!!" Watch "Oracle Stored Procedures --- URGENT!!!!!" New topic

Oracle Stored Procedures --- URGENT!!!!!

Ram Pra
Ranch Hand

Joined: Feb 06, 2001
Posts: 37
Hello ,
I am trying to use stored procedures instead of embedded sequels.I am stuck in creating the stored procedure for a simple select statement and retrieving the results back in my programme.Could any one please send me a sample code of both the stored proc and the java code.In fact i want to know how do i retrieve multiple results in my programme.
I am using Oracle 8i.
rani bedi
Ranch Hand

Joined: Feb 06, 2001
Posts: 358
You shud refer to the JDBC tutorial on sun site.

Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
I agree. Here's the link:
subject: Oracle Stored Procedures --- URGENT!!!!!
It's not a secret anymore!