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

execute stored procedure with jodd-db #389

Closed
moh-sushi opened this issue Jan 26, 2017 · 2 comments
Closed

execute stored procedure with jodd-db #389

moh-sushi opened this issue Jan 26, 2017 · 2 comments
Assignees
Milestone

Comments

@moh-sushi
Copy link
Member

There is no support of executing a stored procedure, isn't it?!

I have found no doc and no reference within code so far....

@igr igr added the jodd-db label Jan 26, 2017
@igr
Copy link
Member

igr commented Jan 26, 2017

Ah, this one is on todo for long time :) 👍

@igr igr added this to the 3.8.5 milestone Jan 26, 2017
@igr igr added the enhancement label Mar 2, 2017
@igr igr self-assigned this Mar 26, 2017
@igr igr closed this as completed in cc9e3c9 Mar 26, 2017
@igr
Copy link
Member

igr commented Mar 26, 2017

Added like this:

DbQuery dbQuery = new DbQuery(session, "{ :upp = call upper( :str ) }");
dbQuery.setString("str", "some lowercase value");
dbQuery.outString("upp");

DbCallResult r = dbQuery.executeCall();

assertEquals("SOME LOWERCASE VALUE", r.getString("upp"));

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

No branches or pull requests

2 participants