I need to have a SQL stored procedure call a Java program. I've seen where an external stored procedure could be the interface to the Java program and then I would have the SQL stored procedure call that external stored procedure. Is this the best way to do this? The only way to do this?
Thanks for your input on this.
CREATE PROCEDURE UPDATE_ITEMS (IN ITEM VARCHAR(100))
DYNAMIC RESULT SETS 0
PARAMETER STYLE JAVA
EXTERNAL NAME 'test.UpdateList';