Guest User

Untitled

a guest
Jan 24th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. Hibernate: 5.4.0.Final
  2. PostgreSql: 9.6.6 (It would be an option to upgrade to latest version)
  3.  
  4. CREATE OR REPLACE FUNCTION myFunction(param1 "A"[], param2 "B") RETURNS SETOF "C" AS $$
  5. BEGIN
  6. ......
  7. END;
  8. $$ LANGUAGE plpgsql;
  9.  
  10. ProcedureCall call = session.createStoredProcedureCall("myFunction");
  11.  
  12. call.registerParameter(1, <Type?>, ParameterMode.IN).bindValue(listOfEntities);
  13. call.registerParameter(2, EntityForTableB.class, ParameterMode.IN).bindValue(entityForTableB);
  14.  
  15. ((ResultSetOutput)call.getOutputs().getCurrent()).getResultList();
  16.  
  17. org.postgresql.util.PSQLException: ERROR: Function myFunction(bytea, bytea) does not exist
Add Comment
Please, Sign In to add comment