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 
 

Reply via email to