As the title says, I am looking for a library that can connect to Progres and execute a stored procedure with either input or output parameters. Or even a user defined function.

I’ve checked the documentation of these three libraries:

  • cl-progres
  • pg-dot-lisp
  • clsql

but there seems to be no mention or example of executing a stored procedure. Is it just not documented? Are there other ways I can do it apart from these three?

    • AxenZh@alien.topOPBEnglish
      1·
      1 year ago

      Thanks. I’ve come across a page describing how to execute stored procedure in CLSQL:

      if you want just execute stored procedure then (execute-command "sp_bla 1, 2")
      If your stored procedure returns table or single value then (query "sp_bla 1, 2")

      which is quite similar to Lispworks apart from wrapping the call to the procedure with PL/SQL BEGIN END pair.
      (sql:execute-command "BEGIN my_procedure(1, 'foo'); END;")