Skip to Content
avatar image
Former Member

how will be outbound data structure in sap xi after executing the stored pr

Hi All

can any one please tell me how will be outbound data structure in sap xi after executing the stored procedure by sender JDBC adapter?

Thanks in advance

regards

Rams

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Oct 15, 2008 at 09:31 AM

    if your scenario is synch ,in your stored procedure you must have some fields as IN and some fields as OUT ,so the structure of OUT type of stored procedure is your structure .

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2008 at 09:35 AM

    Clear few things

    your stored procedure is Select or Insert.

    which structure you r looking Source or Target.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi..

      My stored procedure is select and it will be OUTBOUND in PI.

      is it will be same as following

      <resultset>

      <row>

      <column-name1>column-value</ column-name1>

      <column-name2></column-name2>

      <column-name3>column-value</ column-name3>

      <column-name4></column-name4>

      </row>

      <row>

      <column-name1>column-value</ column-name1>

      <column-name2></ column-name2>

      </row>

      </resultset>

      Regards

      Rams

      Edited by: Rameshkumar Varanganti on Oct 15, 2008 12:04 PM

  • Oct 15, 2008 at 10:26 AM

    check this blog JDBC Stored Procedures

    If you are selcting data from database then use Source structure root name would be root name of your data type.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2008 at 10:40 AM

    In JDBC Sender Adapter write SQL_EXECUTE CALL <STOTEDPROCEDURENAME> thin in Query SQL statement to Execute stored procedure.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2008 at 10:35 AM

    thanks all

    Add comment
    10|10000 characters needed characters exceeded