0

In Spring Boot (language used is Java), I have written like this to call procedure from PostgreSQL.

String sqlQuery = "{CALL SP_GENERATE_OTP(?,?,?,?,?)}";

Is this correct way to call procedure? Please help me to solve this error.

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
sp k
  • 25
  • 4
  • check if this answer works for you https://stackoverflow.com/a/54753891/6228210 or [using query annotation](https://stackoverflow.com/a/68030744/6228210) – Richard Jul 22 '22 at 09:15
  • its not working – sp k Jul 22 '22 at 09:35
  • https://stackoverflow.com/questions/54732196/cant-call-postgresqls-11-stored-procedure-with-hibernate –  Jul 22 '22 at 09:43
  • i had tried this also still getting error – sp k Jul 22 '22 at 09:46
  • 2
    Nope, this is just a String assignment. And "its not working" is the worst possible description of an error. Please post your complete code and the precise error message. – Gyro Gearless Jul 22 '22 at 09:54

0 Answers0