Scala & Slick stored procedure examples

[Robin Holtmann]

Hi all,

I am thinking about using Slick with Playframework 2.0.
Are there Slick examples with stored procedures?
Especially stored procedures with multiple result sets and how to write those results in lists of tuples.

Thanks in advance
Robin

[Christopher Vogt]

http://slick.typesafe.com/doc/1.0.0/lifted-embedding.html#query-templates

and some in the slides at

http://slick.typesafe.com/docs/

[Egon Nijns]

Hi Christopher,

can you please elaborate on your answer?

I can't see how these links relate to the use of stored procedures for querying.

kind regards,
Egon.

[Christopher Vogt]

I just noticed I missed the "multiple result sets" in the original question. Multiple result sets are currently not supported. For a single result set you can use Slick plain sql queries, optionally using the interpolation syntax like this:

sql"{call myproc($a, $b)}".as[(String, Int, Int)]

For type-safe embedding of scalar functions please refer to the documentation linked before and search for SimpleFunction.

Chris