Can the JDBC adapter handle User Defined Table types as Input parameters ?

[Former Member]

Im currently trying to call a Stored Procedure with a User Defined Table Type as the input paramter.... The XML looks similar to this ..

<Statement>

     <SP_STATEMENT_NAME action="execute">

          <table>SP_STATEMENT_NAME</table>

          <USER_DEFINED_TABLE_TYPE type="USER_DEFINED_TYPE>

               <FIELD1>FOO</FIELD1>

               <FIELD2>BAR</FIELD2>

          </USER_DEFINED_TABLE_TYPE>

     </SP_STATEMENT_NAME>

</Statement>

It would seem that the SAX parser doesnt like the USER_DEFINED TABLE TYPE as an ARGUMENT and wants just a simple type ....

[nabendu_sen]

Hi Richard,

I dont think you would be able to achieve this with custom structure. As per the SAP it should like below:

<StatementName5>

<storedProcedureName action=” EXECUTE”>

    <table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

  </StatementName5>

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

[Former Member]

Thanks, Im wondering if anyone has actually done this with a User Defined Table Type in PI. The standard Doco linked doesnt really help ...... well as best I can tell .....

I have a stored procedure where the input parameter is a table type <- passing a table to stored procedure ....

In the context of my original post what should the XML sent to the adapter look like ...?

It seems that the PI JDBC Receiver adapter is not built to handle TABLE arguments, just normal typed parameters ?