Skip to Content
avatar image
Former Member

IDOC TO JDBC with many store procedures

Hi all,

I'm developing an IDOC to JDBC interface that should update 3 different store procedures with the same idoc.

In the data type of the JDBC I wrote 3 different actions, one for each table of the store, but the following message appears :

Attribute "name" of element "/schema/complexType("RQ_VMI004PI_2JDBC_DT")/sequence/element("STATEMENT")/complexType/sequence/element("ROWS")/complexType/attribute("action")" has the value "action" that has been already used in element "/schema/complexType("RQ_VMI004PI_2JDBC_DT")/sequence/element("STATEMENT")/complexType/sequence/element("ROWS")/complexType". Ensure that all attributes and elements of each element have unique names when using the data type (enhancement) editor

Is possible to update 3 different tables using store procedures with the same data type or i have to create 3 different data types? Any idea?

Regards,

Roxana.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 15, 2009 at 02:32 AM

    I am not sure if you can execute 3 SPs in a single transaction. Best way is to create a 4th SP which call these 3 SPs inside it.

    VJ

    Add comment
    10|10000 characters needed characters exceeded