As far as I Know a Java stored procedure is a stored procedure written in Java, which can be called from an external java client using jdbc callable statement, exactly as any other pl/sql stored procedure. So does Websphere JDBC Adapter on ESB or WPS support invoking java stored procedure as any other stored procedure? RDBMS is oracle 11g, WPS/WAS/JBC Adapter version is 7.0.x . (I haven't found a clear infocenter reference on this, and I don't have customer's reference to its java stored procedures and database yet to test directly).
This topic has been locked.
2 replies Latest Post - 2013-02-28T17:43:49Z by SystemAdmin
Pinned topic JDBC Adapter and Java Stored Procedure
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-28T17:43:49Z at 2013-02-28T17:43:49Z by SystemAdmin
Re: JDBC Adapter and Java Stored Procedure2013-02-28T17:16:53Z in response to SystemAdminI found on infocenter http://publib.boulder.ibm.com/infocenter/dmndhelp/v7r0mx/topic/com.ibm.wsadapters.jca.jdbc.doc/doc/cjdb_storedfunctionsov.html the following statement:
For Oracle databases, the adapter supports stored functions that a user creates with the CREATE FUNCTION statement. Although this type of function is sometimes called a user-defined function (UDF), that term more refers to a Java™ stored function or procedure, which the adapter does not support.
I am not really sure to understand: does it mean there is no support to java stored procedure at all?