To call a Java method using Interactive SQL

1. Create the following SQL stored procedure to call the Invoice.main method in the sample class:

   CREATE PROCEDURE InvoiceMain( IN arg1 CHAR(50) ) EXTERNAL NAME 'Invoice.main([Ljava/lang/String;)V' LANGUAGE JAVA;

   This stored procedure acts as a wrapper to the Java method.

   For more information about the syntax of this statement, see CREATE PROCEDURE statement.

2. Call the stored procedure to call the Java method:

   CALL InvoiceMain('to you');

   If you examine the database server message log, you see the message "Hello to you" written there. The database server has redirected the output there from System.out.