Hi guys!
Suppose I am having an Oracle Stored Procedure with signature:
callMe(IN param String, OUT param SYS_REFCURSOR) {
...
}
This procedure suppose to return ResultSet
How can I "simulate" this procedure using H2?
I looked at:
http://www.h2database.com/html/features.html#user_defined_functions
But example provided there does not take any params ;/
there is a Java code there:"
public static ResultSet simpleResultSet() throws SQLException {
SimpleResultSet rs = new SimpleResultSet();
rs.addColumn("ID", Types.INTEGER, 10, 0);
rs.addColumn("NAME", Types.VARCHAR, 255, 0);
rs.addRow(0, "Hello");
rs.addRow(1, "World");
return rs;
}
CREATE ALIAS SIMPLE FOR "org.h2.samples.Function.simpleResultSet";
How this shuld look like when I have OUT param of type SYS_REFCURSOR? :)
Regards,
Adam
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
