OK Hofri, I got the message.

Last question is about "table of these types". In JDBC, we use java.sql.Array and oracle.sql.STRUCT to get the data.
Is it really supported too?

Here is the case:
http://www.mail-archive.com/user-java@ibatis.apache.org/msg07567.html

----- Original Message ----
From: Hofri Yehuda <Yehuda.Hofri@comverse.com>
To: user-java@ibatis.apache.org
Sent: Sunday, February 4, 2007 12:24:32 PM
Subject: RE: Does iBATIS supoort user defined Oracle Types?

All oracle types can be called upon using primitive java types, it isn't a question of telling your client "no, can do..", everything can be done usign the basic java types...
i wouldn't do the above casting because it grows dependency on the DB driver and adds the serialization and cast burden.


From: Luis A [mailto:java_prog_luis@yahoo.com]
Sent: Sunday, February 04, 2007 12:11 PM
To: user-java@ibatis.apache.org
Subject: Re: Does iBATIS supoort user defined Oracle Types?

Oh, what a rapid answer :) Thank you Hofri.

Is there a page explaining how to do?

We have been working with a third party company and sadly we have no chance to say "please dont use those types".

Thanks in advamce.

----- Original Message ----
From: Hofri Yehuda <Yehuda.Hofri@comverse.com>
To: user-java@ibatis.apache.org
Sent: Sunday, February 4, 2007 11:59:43 AM
Subject: RE: Does iBATIS supoort user defined Oracle Types?

yep, but it isn't recommended using them !!!


From: Luis A [mailto:java_prog_luis@yahoo.com]
Sent: Sunday, February 04, 2007 11:58 AM
To: user-java@ibatis.apache.org
Subject: Does iBATIS supoort user defined Oracle Types?

Hi all,

Does iBATIS supoort user defined Oracle Types?

Thanks.


Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel
to find your fit.



8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.



We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.