</parameterMap>

<procedure id=3D"example"

parameterMap=3D"exampleParam">

{call example(?,?,?,?,?,?,?,?,?,?,?)}<= /P>

</procedure>

</sqlMap>

On Jan 30, 2008 3:37 PM, Sundar = Sankaranarayanan <Sundar.Sankaranarayan= an@phoenix.edu>=20 wrote:

Hi All,

I have a stored = procedure, which is=20 something like this.

call=20 example(?,?,?,?,?,?)

The first four params are IN = params and the=20 last 2 are out params. If I set the mode=3D"OUT" or set the mode as = "INOUT" in=20 the sql-map xml file I get a

         =       =20 --- Cause: java.sql.SQLException
: Invalid column type; nested exception is = com.ibatis.common.jdbc.exception.NestedSQLException:
         &nbs= p;     =20 --- The error occurred in=20 ibatis/config/procedures/example.xml.

         &nbs= p;     =20 --- The error occurred while executing query procedure.=20

         &nbs= p;     =20 --- Check the {call=20 example(?,?,?,?,?,?)}

         &nbs= p;     =20 --- Check the output parameters (register output parameters = failed).=20

        &n= bsp;      =20 --- Cause:=20 java.sql.SQLException: = Invalid column=20 type

         =       =20 at=20 = org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate= (SQLStateSQLExceptionTranslator.java:121)

         =       =20 at=20 = org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.trans= late(SQLErrorCodeSQLExceptionTranslator.java:322)

         =       =20 at=20 = org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:197)

         =       =20 at=20 = org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult= (SqlMapClientTemplate.java:220)

         =       =20 at=20 = org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(<= U>SqlMapClientTemplate.java:267)

         =       =20 at=20 = com.apollo.sisaw.entry.dao.implementation.IbatisTranscriptActivityDaoImpl= .insertTranscriptActivity(IbatisTranscriptActivityDaoImpl.java:408)

         =       =20 at=20 = com.apollo.sisaw.entry.dao.implementation.IbatisTranscriptActivityDaoImpl= Test.testInsertTranscriptActivity(IbatisTranscriptActivityDaoImplTest.java:197)

         =       =20 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native = Method)

.

The procedure does run fine if = I change the=20 mode to "IN" but the values that I expect to be set into the input map = I=20 provide is being set as null. I dont know what has to be done. I am = using=20 Spring with Ibatis together and have an oracle database. Any help on = this is=20 appreciated.

Thanks and = Regards

Sundar=20 .