Annotation Type OutParameter


Declare a named out parameter on an @SqlCall annotated method. Note that you *must* include the parameter name in the SQL text to ensure that the binding is activated, this is a limitation that may be fixed at a future date. Example usage, using PostgreSQL call syntax:
   handle.execute("CREATE FUNCTION set100(OUT outparam INT) AS $$ BEGIN outparam := 100; END; $$ LANGUAGE plpgsql");

   @SqlCall("{call myStoredProc(:outparam)}")
   @OutParameter(name="outparam", sqlType = Types.INTEGER)
   OutParameters callStoredProc();
 
  • Required Element Summary

    Required Elements
    Modifier and Type
    Required Element
    Description
     
    int
     
  • Element Details

    • name

      String name
    • sqlType

      int sqlType