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).]