Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Ram Pra
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Thanks
Prashanth
 
rani bedi
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You shud refer to the JDBC tutorial on sun site.
http://java.sun.com/docs/books/tutorial/jdbc/TOC.html#basics
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic