Hi, In the current state of H2 1.4.17, there is no way to retrieve procedure return type. However JDBC Api of DataBaseMetaData#getProcedureColumns specify that *ORDINAL_POSITION* at 0 mean return value of procedure. PostGreSQL follow JDBC Api for this point.
Here the patch in order to return the return type of procedures: https://github.com/nicolas-f/H2-Mirror/compare/meta_procedures https://github.com/nicolas-f/H2-Mirror/compare/meta_procedures.diff https://github.com/nicolas-f/H2-Mirror/compare/meta_procedures.patch There is some duplicated lines in the patch. I prefer to leave it as is for the sake of diff clarity. I would like to see the patch applied to 1.3.X but as SVN does not support branch it is impossible.. Thanks for support. Best regards, Nicolas Fortin, RISING FR IRSTV 2488 -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
