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

Calling Stored Procedures #132

Closed
madhuraadawadkar opened this issue Nov 23, 2020 · 1 comment
Closed

Calling Stored Procedures #132

madhuraadawadkar opened this issue Nov 23, 2020 · 1 comment

Comments

@madhuraadawadkar
Copy link

How can I invoke a stored procedure using objectionjs?
I tried invoking with knex by using
knex.raw('Call TEST_SP(1);')
It was executed correctly and got the result in Raw format (row values in TextRow object).
How do I convert this result to json, so I can send it in response?

@dekelev
Copy link
Member

dekelev commented Nov 27, 2020

ObjectionJS does not support calling functions/procedures, so it can only be done with knex directly. you can read more about it here.

@dekelev dekelev closed this as completed Nov 27, 2020
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

2 participants