Re: Oracle iBatis documentation

out, when calling the sp, whether I need > to pass one variable (which is 'in') or do i need to pass something as the > second (which is 'out') as well? > > > On Fri, Feb 27, 2009 at 12:38 AM, Roger Voss wrote: > >> How about this: >>

Re: Oracle iBatis documentation

How about this: http://ibatis.apache.org/dtd/sql-map-2.dtd";> On Thu, Feb 26, 2009 at 9:25 PM, Bhaarat Sharma wrote: > Hi, > > We have been using iBatis with sql server but now we are moving to Oracle. > Our stored procs will be changed to oracle as well. I

Re: "resultMap" must be declared for element type "parameter".

Turn your Oracle procedure call into a function where the cursor is returned as the function result and then wrap the call like so: SELECT * FROM TABLE(Tree.GETTREEINFO(?)) You will then be able to get iBATIS to map this using a resultMap definition - just as though were selecting from an ordinar

Re: Spring - Ibatis Stored Procedure Call

custom parameterMap classes as inner private static final classes as they often have utility limited to just the scope of the code that is making the stored procedure call.) --Roger On Fri, Jan 2, 2009 at 9:55 PM, Roger Voss wrote: > For a single custom Java class you can have a single iba

Re: Spring - Ibatis Stored Procedure Call

For a single custom Java class you can have a single ibatis parameterMap that maps both inputs (mode="IN") and outputs (mode="OUT") to the stored procedure call - or even have class members that are both (mode="INOUT"). Place your output as the last item in your (I'm assuming your last positiona

Re: Oracle SQL DATE conversion problem using iBATIS via Java JDBC

roblem. Where you might notice a > difference is if you relied on the conversion from DATE to Date to > truncate the time component or if you do toString on the value. Otherwise > the change should be transparent. > > If for some reason your app is very sensitive to this change and you

Oracle SQL DATE conversion problem using iBATIS via Java JDBC

I posted following question/problem on stackoverflow, so if anyone knows a resolution, would be good to see it answered there: Oracle SQL DATE conversion problem using iBATIS via Java JDBC Her