Hi Satish, Just in case you were wondering how to do this. I found this url for "passing arrays into pl/sql stored procedures"
Read through this. It will help. Nothing to do with iBatis though. http://asktom.oracle.com/pls/ask/f?p=4950:8:1320218815388063256::NO::: Hope you will get some help from here. Rgds Prashanth Sukumaran. --- "Rao, Satish" <[EMAIL PROTECTED]> wrote: > I am using Oracle. Not sure if it allows "LIST" Data Type. > > -----Original Message----- > From: Prashanth Sukumaran [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 10, 2005 5:17 PM > To: [email protected] > Subject: RE: Complex type as IN parameter > > > Hi Satish, > > What Database are you using? Does it allow you to define a DATA TYPE > "LIST". > > Thanks > > Prashanth Sukumaran. > > --- "Rao, Satish" <[EMAIL PROTECTED]> wrote: > > > Hi Prashanth, > > > > What I want to know is how to pass a list as a IN paramater to stored > > procedure? > > What would the corresponding sqlMap entry look like and what would the > > stored procedure declaration for that IN variable. > > > > > > -----Original Message----- > > From: Prashanth Sukumaran [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 10, 2005 4:55 PM > > To: [email protected] > > Subject: Re: Complex type as IN parameter > > > > > > Hi Satish, > > > > You must be using a iterator if you are passing a List as a parameter > > right. Also > > you have defined TBL_ORD_ID as TEST_TABLE.ORD_ID%TYPE. > > > > I have never heard of any database that defines/has a list Data Type. > > Is there any??? > > > > If not then defined the type of ORD_ID. > > > > Rgds > > > > Prashanth Sukumaran. > > > > --- "Rao, Satish" <[EMAIL PROTECTED]> wrote: > > > > > In one of our stored procedure, we have the following declaration > > > > > > TYPE TBL_ORD_ID IS TABLE OF TEST_TABLE.ORD_ID%TYPE; > > > > > > PROCEDURE PRC_ORDER_S > > > ( > > > IN_TBL_ORD_ID IN TBL_ORD_ID, > > > ................... > > > > > > Functionally, I can call that stored procedure with a single orderId > > or > > > a list of orderIds as input. > > > > > > What would the entry for jdbcType and javaType in the sqlmap be? > > > > > > <parameter property="orderId" mode="IN" jdbcType="?" > > > javaType="?"/> > > > > > > > > > > > > > > > > > > > ____________________________________________________ > > Start your day with Yahoo! - make it your home page > > http://www.yahoo.com/r/hs > > > > > > > > > ____________________________________________________ > Start your day with Yahoo! - make it your home page > http://www.yahoo.com/r/hs > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
