Thanks Brandon (and Jeff), I'm definitely going to try that. I thought I was confined to the types declared in the JdbcTypeRegistry class. In that class there is a "ORACLECURSOR" declared - which I can pass onto a stored function/procedure as JDBCType when I want to do something with REF Cursors.
However there is no OPAQUE in the JdbcTypeRegistry in case I want to do something with XMLType. I'm aware of the fact that Oracle uses this custom type as supporting datatype for XMLType - as I indeed wrote the XMLTypeHandlerCallback. Am I correct in that you're telling me now that I can set jdbcType="OPAQUE" regardless of that type not being in the JdbcTypeRegistry? Thanks. -J. > I noticed that you were the one that wrote the XMLTypeHandlerCallback. > Sorry, I wasn't getting what you wanted. My bad. Now that i see what you > are > saying I did a little searching and came up with this display on how > Oracle > handles it with straight JDBC. It appears that they specify it as OPAQUE. > > http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jsp/xmltype/index.html > > Hope that helps, > Brandon > > On 2/16/07, Jan Vissers <[EMAIL PROTECTED]> wrote: >> >> > True/False - You have a procedure that you are calling >> False - it's a stored function (Oracle) >> >> > True/False - You have an OUT/INOUT Parameter that is returning as an >> > ORACLECURSOR >> False - it's an Oracle XMLType (Oracle specific datatype) >> >> > True/False - You want to convert this returned ORACLECURSOR to xml >> False - See above >> >> _j >> >> >> > Help get this straight in my noggin :) >> > >> > True/False - You have a procedure that you are calling >> > True/False - You have an OUT/INOUT Parameter that is returning as an >> > ORACLECURSOR >> > True/False - You want to convert this returned ORACLECURSOR to xml >> > >> > If i'm all false here then please explain to me what you want to >> > accomplish >> > and leave out any ibatis terms. For example, "I have a procedure that >> > returns a resulset/cursor. I want to convert it to xml. How do i do >> that?" >> > >> > Brandon >> > >> > On 2/16/07, Jan Vissers <[EMAIL PROTECTED]> wrote: >> >> >> >> Guess so... or maybe I'm stupid. >> >> >> >> Given the XmlTypeHandler which is in the wiki what should I set the >> >> JDBCType to in the inline parameter map, >> >> when clearly there is no fitting type in the JdbcRegistry. For Oracle >> >> REF CURSORs we've got ORACLECURSOR >> >> but do we have for Oracle's XMLTYPE ??? Tried OTHER and OBJECT... >> >> >> >> Hope this clears things up a bit. >> >> -J. >> >> >> >> >> >> Brandon Goodin wrote: >> >> > I guess i don't understand what you are asking. A TypeHandler >> handles >> >> > *a* type from/to the database. It seems to me like you are >> >>%
