How can I pass Array of (ArrayList) POJOs to stored procedure

[Tamilselvan Radha Krishnan <Ta...@igate.com>]

Hi,
I need to pass a Array of data (POJO) into Oracle stored procedure so
that I will be inserting or updating the records using Ibatis.  

Can any one suggest me the solution with an example?

Thanks in advance.

Regards

Tamil
|Technical Lead| iGATE Global Solutions Limited|Office: 52250000 Extn
2271| tamilselvan.radhakrishnan@igate.com| 106-109, MAC Commerce park,
Anna Salai, Guindy, Chennai 600032 India | Website: www.igate.com


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual 
or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under 
applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or mailadmin@igate.com 
and delete this EMAIL including any attachments
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Re: How can I pass Array of (ArrayList) POJOs to stored procedure

[Larry Meadors <lm...@apache.org>]

There is nothing built in to do this, so you will have to do it with a
batch, or with some string parsing trickiness in pl/sql.

Larry


On 11/24/06, Tamilselvan Radha Krishnan
<Ta...@igate.com> wrote:
>
>
>
> Hi,
>
> I need to pass a Array of data (POJO) into Oracle stored procedure so that I will be inserting or updating the records using Ibatis.
>
>
>
> Can any one suggest me the solution with an example?
>
> Thanks in advance.
>
>
>
> Regards
>
> Tamil
>
> |Technical Lead| iGATE Global Solutions Limited|Office: 52250000 Extn 2271| tamilselvan.radhakrishnan@igate.com| 106-109, MAC Commerce park, Anna Salai, Guindy, Chennai 600032 India | Website: www.igate.com
>
>
>
>
>
>
>
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>
>  Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual
>  or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under
>  applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or mailadmin@igate.com
>  and delete this EMAIL including any attachments
>  _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _