How To Write A Java Stored Procedure

• Write the *.java source code

• Compile to the *.class files

• INSTALL the classes in the database

• Write the wrapper sp *.SQL source code

• CREATE the wrapper sp

• CALL the wrapper sp

Previous slide

Next slide

Back to first slide

View graphic version

For various reasons you may want to call Java code from within a "wrapper" stored procedure written in Watcom SQL. To do this you have to write, compile and store your Java classes in the database, then write and CREATE the stored procedure that uses the Java code, and finally run a test to CALL the stored procedure.