PURE Java™ 2

Using Callable Statements

The third kind of statement that Java supports is a CallableStatement, which supports stored procedures. Because InstantDB does not (as of September 1999) support stored procedures, I will show you a code snippet that you can modify to work with stored procedures in your code. The format for stored procedures varies from vendor to vendor, so you should check your DBMS vendor's documentation to see how to use a stored procedure from Java. As noted earlier, a stored procedure is a set of SQL statements stored in the database itself.

Note

Some vendors, notably Oracle, are adding support for coding stored procedures in Java, but this is not supported widely yet. In Oracle's case, there is a JVM embedded in the database engine. ...