cancel
Showing results for 
Search instead for 
Did you mean: 

Call Stored procedure with deep structure

Emre_tr
Active Participant
0 Kudos
226

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

View Entire Topic
former_member182412
Active Contributor
0 Kudos

Hi Emre,

The stored procedure format you can find here Defining an EXECUTE Statement - Advanced Adapter Engine - SAP Library,

Stored procedure does not support nested structures.Check these blogs for more info.

Regards,

Praveen.

Emre_tr
Active Participant
0 Kudos

Thank you Praveen,

I have checked these documents, It's fine for simple scenario. But for complex structures i have problem.

former_member182412
Active Contributor
0 Kudos

Hi Emre,

These data types only supported by stored procedure.


You must specify the attribute type=<SQLDatatype> for all parameter types (IN, OUT).

It describes the valid SQL data type.

The following SQL data types are supported:

INTEGER, BIT, TINYINT, SMALLINT, BIGINT, FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL, CHAR, VARCHAR, STRING, LONGVARCHAR, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, LONGVARBINARY, BLOB (input and output), CLOB (input and output), CURSOR (output; only in connection with the Oracle JDBC driver)

The reason for above error is the data type for EDUCATION is EDUCATION_Items which is not supported.

Regards,

Praveen.