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
