JDBC Call Procedure does not support Oracle xmltype

[Menno Kremers]

I'm trying to implement a JDBC Call Procedure to invoke a Oracle procedure that returns (among others) an Oracle xmltype output parameter.

procedure p_get_data(p_in in number

, p_data out xmltype

, p_status out varchar2);

But when I select this procedure in the JDBC Call Procedure Configuration tab via 'Select Procedure/Fuction' the popup shows 'No Output Parameters'. And this is the case for all procedures or functions that use a xmltype parameter or return type.

Using:

 

JDBCDriver = "oracle.jdbc.driver.OracleDriver (thin)"

ojdbc6.jar (JDBC Driver 11.2.0.3.0) with xdb6.jar and xmlparserv2-19.3.0.0.jar.

Oracle Database 18c Enterprise Edition Release 18.0.0.0

BW 15.4

TIBCO Designer 5.11.0.10