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
