Topic
  • 1 reply
  • Latest Post - ‏2014-02-26T02:41:44Z by NickLawrence
bjbbarker
bjbbarker
17 Posts

Pinned topic SQL stored procedure calling Java

‏2014-02-21T21:45:49Z |

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
LANGUAGE JAVA
PARAMETER STYLE JAVA
EXTERNAL NAME 'test.UpdateList';