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 Sukumara
Hi Satish,
I see that Ibatis has a JDBCTypeRegistry.java that defines all the different
JDBCTypes. It has a
reference to
setType("ARRAY", Types.ARRAY);
May be you can pass a array to the Stored Procedure if not a list.
I don't know if there is documentation for this.
Can a
Well, as far as I know in Oracle passing arrays to Prepared/Callable
procedures is posible BUT is part of Oracle extensions, i.e. requires
casts to OraclePreparedStatement and OracleCallableStatement.
So at least with Oracle it will be impossible (as SqlExecutor
explicitely uses java.sql.Callable
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: user-java@ibatis.apache.org
Subject: RE: Complex type as IN parameter
Hi Satish,
What Database are
tored
> 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:
]
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
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 S
Title: Complex type as IN parameter
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
