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

Status of stored procedure support? #41

Open
RedRoserade opened this issue May 14, 2014 · 2 comments
Open

Status of stored procedure support? #41

RedRoserade opened this issue May 14, 2014 · 2 comments
Assignees

Comments

@RedRoserade
Copy link

I've been trying to call a stored procedure with sqljocky, however, this doesn't work.

I've used straight queries, prepared queries, queries in a connection, and they all fail with Error 1312 (0A000): PROCEDURE db.procedureName can't return a result set in the given context

_pool.query('CALL procedureName(1)')
        .then((testResults) => testResults.toList())
        .then((testResults) {

This procedure does return a result set.

@jamesots
Copy link
Collaborator

Thanks for the defect report. I hadn't tried using stored procedures so hadn't spotted this. I'll try to fix it soon.

@jamesots jamesots self-assigned this May 15, 2014
@pstjvn
Copy link

pstjvn commented Jan 22, 2015

+1
Same happens here, yet it is in the integration test...
I am stuck with old DB and need to use it from dart, rewriting all procedures would be really bad..

Can you provide ETA or at least how high is this on your agenda? I.e. should we wait for it or to look for workarounds.

Thanks

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

No branches or pull requests

3 participants