Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes 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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic