How can I call MySQL stored procedure in ecto(=> 0.11)?

Question

I am looking for a way to use call stored procedure, there was no found. Is it possible in an elixir's ecto lib?

score 7 · Answer 1 · answered May 06 '15 at 06:35

7

You can go directly through the SQL adapter API:

Ecto.Adapters.SQL.query(YourRepo, "stored_procedure(?, ?)", [param1, param2])

answered May 06 '15 at 06:35

José Valim

Error occurred in in MySQL 5.x. (** (Mariaex.Error) unsupported query) – aposto May 07 '15 at 02:41
1

Oops, I believe you need to use CALL before calling the procedure in MySQL. – José Valim May 07 '15 at 09:25

1 Answers1