Hello guys,
Suppose I am having an Oracle Stored Procedure with signature:
callMe(IN param String, OUT param SYS_REFCURSOR) {
...
}
I Set de mode oracle in h2 my functis is this:
DROP ALIAS IF EXISTS LOGPROCESSOR_GETSTATUSREPORT2;
CREATE ALIAS LOGPROCESSOR_GETSTATUSREPORT2 AS $$
@CODE
java.sql.ResultSet getTableContent(java.sql.Connection con, final String
cv_1, final String SYS_REFCURSOR) throws Exception {
String resultValue=null;
java.sql.ResultSet rs = con.createStatement().executeQuery(
"SELECT IDTLOG,DATE,IDSTORE,INIUPLOAD FROM
LOGPROCESSOR_GETSTATUSREPORT");
/*while(rs.next())
{
resultValue=rs.getString(1);
}
return resultValue;*/
return rs;
}
$$;;
This is my
error:
How this shuld look like when I have OUT param of type SYS_REFCURSOR?
Thanks!
--
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.
