Skip to Content
0
Apr 06, 2016 at 06:37 AM

Call Stored procedure with deep structure

121 Views

Dear All,

We have a stored procedure with deep structure. Is there a way to pass values to stored procedures? For simple structures it's working but i have tried to pass values to the inside table PI gives an error like 'unsupported parameter type'. Is there any one faced same problem?

Structure format;

@action = EXECUTE

table = dbo.Sp_Insert_Employee


<Employee> 1..1

<Pernr>

<ename>

<EDUCATION> 1..N

<Id>

<Name>

<Begin>

Error Details;

Transmitting the message to endpoint <local> using connection SOAP_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. dbo.Sp_Insert_Employee (structure EDUCATION): java.sql.SQLException: Unsupported parameter type dbo.EDUCATION_Items for parameter EDUCATION found