Do you have an example for this one? I am trying to call the H2 stored procedure via mybatis, but when I give any out parameters defined , it gives me an error saying ### Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Invalid value "19" for parameter "parameterIndex" [90008-168] same stored proecedure call works fine with oracle
On Monday, June 25, 2012 6:48:26 AM UTC-7, Noel Grandin wrote: > > H2 does not implement in/out parameters, you'd either need to > (a) pass some kind of carrier object into the method that could be > updated, > (b) return your data in a carrier object > (c) return your data in a result set > > On 2012-06-25 15:42, steve.ebersole wrote: > > Following along with > > http://www.h2database.com/html/features.html#user_defined_functions I > > am trying to create a stored procedure that will "return" some > > results. The link I mentioned makes no real distinction between > > functions and procedures, so I am assuming that procedures simply have > > a void return? > > > > Ultimately, I am uncertain how to handle OUT/INOUT parameters. Is that > > possible in H2? > > -- > > You received this message because you are subscribed to the Google > > Groups "H2 Database" group. > > To view this discussion on the web visit > > https://groups.google.com/d/msg/h2-database/-/XbnFQg-ZES4J. > > To post to this group, send email to > > [email protected]<javascript:>. > > > To unsubscribe from this group, send email to > > [email protected] <javascript:>. > > For more options, visit this group at > > http://groups.google.com/group/h2-database?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/SfX64qV3tb0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
