ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rao, Satish" <satish....@fmr.com>
Subject Complex type as IN parameter
Date Wed, 10 Aug 2005 20:09:29 GMT
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="?"/>



Mime
View raw message