> 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 >> > misunderstanding the purpose of a type handler. I would recommend you >> > to the iBATIS SQLMap Guide ( >> > http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf ). >> > Either that or you need to give me a more precise understanding of >> > what you are wanting to accomplish. >> > >> > Regards, >> > Brandon >> > >> > On 2/16/07, *Jan Vissers* <[EMAIL PROTECTED] >> > <mailto:[EMAIL PROTECTED]>> wrote: >> > >> > Any idea...? >> > >> > Brandon Goodin wrote: >> > > TypeHandlers work the same for procedure results as they do for >> > > anything else. Are you having a specific problem? >> > > >> > > Brandon >> > > >> > > On 2/15/07, *Jan Vissers* < [EMAIL PROTECTED] >> > <mailto:[EMAIL PROTECTED]> >> > > <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>> >> > wrote: >> > > >> > > This might be a stupid question, >> > > >> > > Is it possible to have something similar to what you can do >> with >> > > TypeHandlerCallbacks and select statements/resultsets >> > > with stored functions and or procedures? >> > > >> > > Thx, >> > > -J. >> > > >> > > >> > >> > -- >> > Cumquat Information Technology >> > De Dreef 19 >> > 3706 BR Zeist >> > T +31 (0)30 - 6940490 >> > F +31 (0)30 - 6940499 >> > W http://www.cumquat.nl >> > >> > E [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> > M +31 6 51 169 556 >> > B http://www.cumquat.nl/technology_atom10.xml >> > >> > >> > >> >> -- >> Cumquat Information Technology >> De Dreef 19 >> 3706 BR Zeist >> T +31 (0)30 - 6940490 >> F +31 (0)30 - 6940499 >> W http://www.cumquat.nl >> >> E [EMAIL PROTECTED] >> M +31 6 51 169 556 >> B http://www.cumquat.nl/technology_atom10.xml >> >> >> >
