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