JDCB receiver with multiple rows in response (execute procedure)

[Former Member]

Hi all,

I have a problem with one interface...I need to execute a procedure in PL/SQL database (this is not a problem), but the problem is with the response, they want to response to PI with a collection objetc 1-n (ocurrence), not a simple parameter.

How can I do that? How can I make the Output field in the request?

Example of type (object response).

RESPONSE

   ITEM        1-n

          FIELD1     1-1

          FIELD2     1-1

Thanks in advance.

[former_member190293 · Accepted solution]

Hi Daniel!

Do you want to receive a table as returned value from the procedure?

If so you should look for function returning table value as result. As for MS SQL Server:

ALTER FUNCTION [dbo].[usfGetBufferState]

(

  -- Add the parameters for the function here

  @UntransferredOnly int

)

RETURNS

  @BufferTable TABLE

[Former Member · Accepted solution]

But, how can I configure the mapping request? I must set a TYPE in the OUTPUT parameter...

[former_member190293 · Accepted solution]

Look at this document, it describes request message structure for SQL query:

Defining an SQL_QUERY Statement - Configuring the JDBC Adapter in the Integration Directory/PCK - SA...

Placeholders are used to pass parameters in query string.

Regards.