Hello,
I try to mock an Oracle database in H2 (as I have sucessfully done
before) for testing. Unfortunately, the application in question uses a
stored procedure called via:
connection.prepareCall("{ ? = call seqIncr (?) }");
now, the output (return) parameter is registered
stmt.setString(2, sequenceName);
stmt.registerOutParameter(1, Types.NUMERIC);
I mocked the stored procedure with a simple function (precompiled in a
Class):
public static int seqIncr(final String ) {
return 1;
}
and linked to the DB via CREATE ALIAS.
Now, when the procedure is called, I get the Error:
Invalid value "2" for parameter "parameterIndex"
Is the ? = call syntax not supported? I did not find any example in
the documentation or here. Or is there any trick to make that work? I
can not change the calling code, at least not easily.
kind regards,
Florian Seidl
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
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.
