Stored procedure

[Former Member]

Hi All

I need to call the stored procedure and make it as sender how do design data type to make stored procedure as sender

Thanks

Jayaraman

[Former Member · Accepted solution]

Hi,

Information on sender jdbc adapter.

http://help.sap.com/saphelp_erp2005vp/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

You don't have to design datatype in different way for sender jdbc adapter.

Only point is that instead of writing query in "Query SQL Statement" parameter you have to write name of stored proc.

Thanks,

Tuhin

[Former Member]

txs

[Former Member]

Hi,

In sender JDBC adapter you have to specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.

Give your procedure name after SQL EXECUTE and then create datatype according to the output of yourprocedure.

Thanks.

[Former Member]

Hi,

The system converts the table resulting from the query SQL statement into a valid XML document and sends it to the Integration Engine. The document looks like this:

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset>

Regards,

Sudheer.