Skip to Content
Former Member
Aug 11, 2011 at 07:11 AM

JDBC receiver adapter - stored procedure response


I am on PI 7.11 and have the following scenario:


whereby the JDBC receiver access an Oracle db (unsure of that version) using a stored procedure "GET_ICBC_ID".

  • My issue is that I never seem to have any data back in PI on the JDBC response coming back from Oracle. ***

Here is the definition of that stored procedure in Oracle:

Stored Procedure Name: GET_ICBC_ID


ICBCID OUT VARCHAR2 <- Returned RACF ID (output)

REQUESTOR IN VARCHAR2 default 'SAPHR' <- Optional Requestor ID.

COMMUNITY IN VARCHAR2 default 'EMP' <- Optional Community ID.

Here is my JDBC call in to the stored procedure (sxi_monitor), which seems to be fine:

<?xml version="1.0" encoding="UTF-8" ?>


- <Statement>

- <GET_ICBC_ID action="EXECUTE">


<COMMUNITY isInput="true" type="CHAR">EMP</COMMUNITY>




It appears as though the call into the JDBC is working, as the Oracle guys have shown me the logs (showing success) on the Oracle side.

This is my sxi_monitor entry (of that response message):

<?xml version="1.0" encoding="utf-8" ?>


<Statement_response />


Also when I look at some of the message properties I see:







which I believe is saying that something came back in to PI as a response?? Not sure.

My Message Type definition is:" xmlns="" targetNamespace="">

<xsd:element name="MT_racf_req_response" type="DT_racf_req_response" />

<xsd:complexType name="DT_racf_req_response">


<xsd:element name="Statement_response" type="DT_statement_response" />



<xsd:complexType name="DT_statement_response">


<xsd:element name="ICBCID" type="xsd:string" />




I have also tried inserting <row> between <Statement_response> and the ICBCID element. Still no luck.

I suspect something is wrong with my response message type definition, but am not seeing it. Also, am unsure how I can debug this - it appears as though Oracle side is fine, but nothing back into PI.

Any thoughts appreciated.