This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Does anyone know any tutorials on CallableStatement?

 
Mindy Wu
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
I am looking for a good tutorials on callable statement topic, somehow, i found the one in sun is not detail enough.
Can anyone tell me the url?
Thanks!
Mindy
Happy Programmer!
 
rani bedi
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
have you tried the java.sql.CallableStatement API
http://java.sun.com/products/jdk/1.1/docs/api/java.sql.CallableStatement.html
 
Desai Sandeep
Ranch Hand
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Mindy,
When it comes to Java Stored Procedures, Callable Statements and Java Triggers, I believe Oracle is supposed to be the best in it.While preparing for their IDE (JDeveloper) test, I has practised on Callable Statement.
Hope the following example is relevant for you.I have used SQLJ instead of JDBC.Hope you are familiar with it.If not, please let me know.
The Java Stored Procedure to be called by Java Application is as follows :

The Java Application which calls the above stored Procedure is as follows

Hope this helps,
Sandeep

  • Sun Certified Programmer for Java 2 Platform Scored 93 per cent
  • Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java Scored 56 out of 59
  • IBM Enterprise Connectivity with J2EE Scored 72 per cent
  • Enterprise Development on the Oracle Internet Platform Scored 44 out of 56

  • [This message has been edited by Desai Sandeep (edited June 01, 2001).]
 
Mindy Wu
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you so much Sandeep! Your examples are really helpful. May I ask you a few more questions? You're a Sun certified and i bet you have good experiece in preparing for the exam. I am planning to take the exam too, however, I wish i can get some study guides or tips ( book and resource site).

Thanks! Happy programmer!
Mindy

[This message has been edited by Mindy Wu (edited June 01, 2001).]
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!