Nested Stored Procedure Call (Mapping) - JDBC Receiver

[Former Member]

Hello everyone!

I´m going to implemet my first Stored Procedure JDCB Receiver interface, and I have a questions.

I now, according to SAP documentation, the XML SQL should be like this:

<param1 type=SQLDatatype>val1

<param1 type=SQLDatatype>val1

<param1 type=SQLDatatype>val1</param1>

</storedProcedureName2 >

</StatementName2>

</storedProcedureName >

</StatementName>

I mean, from inside the execution of one Stored Procedure, execute another.

Does anyone have this sort of situation also?

I haven't tried yet, but I´m not sure if it would work..

Thanks!!!!

Ricardo Sancio Lóra

Brazil

[former_member187339]

Hi Ricardo,

This may not work

<StatementName>
<storedProcedureName action=u201D EXECUTEu201D>
<param1 isInput=u201Dtrueu201D type=SQLDatatype>val1</param1>
<StatementName2>
<storedProcedureName2 action=u201D EXECUTEu201D>
<param1 isInput=u201Dtrueu201D type=SQLDatatype>val1</param1>
</storedProcedureName2 >
</StatementName2>
</storedProcedureName >
</StatementName>

but this may work

<StatementName>
<storedProcedureName action=u201D EXECUTEu201D>
<param1 isInput=u201Dtrueu201D type=SQLDatatype>val1</param1>
</storedProcedureName >
</StatementName>
<StatementName2>
<storedProcedureName2 action=u201D EXECUTEu201D>
<param1 isInput=u201Dtrueu201D type=SQLDatatype>val1</param1>
</storedProcedureName2 >
</StatementName2>

If you want to execute one SP inside another then it is better to do it in Database level itself

Regards

Suraj

[Former Member]

As per the format published on sap help site nested calls are not supported, lets see what you get on your try!

regards