ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rao, Satish" <satish....@fmr.com>
Subject RE: Complex type as IN parameter
Date Wed, 10 Aug 2005 21:18:27 GMT
I am using Oracle. Not sure if it allows "LIST" Data Type.

-----Original Message-----
From: Prashanth Sukumaran [mailto:prashanthsukumaran@yahoo.com] 
Sent: Wednesday, August 10, 2005 5:17 PM
To: user-java@ibatis.apache.org
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" <satish.rao@fmr.com> 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:prashanthsukumaran@yahoo.com] 
> Sent: Wednesday, August 10, 2005 4:55 PM
> To: user-java@ibatis.apache.org
> 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" <satish.rao@fmr.com> 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 
 

Mime
View raw message