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

Call Stored procedure with deep structure


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







Error Details;

Transmitting the message to endpoint <local> using connection SOAP_ failed, due to: 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