Skip to Content
avatar image
Former Member

How to pass multiple rows to a Stored Procedure(JDBC Receiver)

Hi,

Scenario : File -->XI --> JDBC.

I need to make one call to SP to pass multiple rows(ex: 100 rows).Oracle DB.

1. How should my stored procedure look like ?

2. How should my data type should look like?

Thankx.

Moni

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 06, 2007 at 05:43 PM

    Hey

    have a look at the following thread

    insert-multiple-rows-with-jdbc-adapter-into-a-data

    Thanx

    Aamir suhail

    Add comment
    10|10000 characters needed characters exceeded