How to Pass Array to soted procedure

[Former Member]

Hi all,

I have a scenario where I am communicating with a database. I need to declare an array of type structure which I will pass to a stored procedure as an OUT parameter.

As you know,while excuting a stored prcedure, the Data ype is of the format:

<Paramater_Name isOutput="true" type="VARCHAR">

</Parameter_Name>

However, according to documentation, I can give attribute 'type' as scalar only.

Any ideas how to pass array to stored procedure??

[Former Member]

Hi,

as far as i know, it is not possible to do that...

if i have something wrong, please let me know.

thanks

venjamin

[Former Member]

So if i have a scenario where i have to insert data into multiple tables and for one header record if i have multiple details records .how should i pass data to the stored procedure..