Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feat: Stored Procedures #28

Open
sparty02 opened this issue Jun 10, 2015 · 2 comments
Open

Feat: Stored Procedures #28

sparty02 opened this issue Jun 10, 2015 · 2 comments

Comments

@sparty02
Copy link
Contributor

(I saw a comment on the README along the lines of supporting Callable statements. Assuming this is where you were heading with that?)

Maybe something like:

String state = db.
        .call("{call GetStateByZip(?)}")
        .parameter(90210)
        .getAs(String.class)
        .first().toBlocking().single();
System.out.println(state);  // California

Stored procedures would support named parameters, as already supported in other queries.

@davidmoten
Copy link
Owner

Seems fair enough. Maybe some basic support first for a use case like you show then later stuff like binding OUT parameters.

@sparty02
Copy link
Contributor Author

Sounds good! Regarding OUT parameters, you could probably leverage the getAs(Class<?>...) part of the API right?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants