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

[Problem]: Calling stored procedure results to error in VSCode #21

Open
AlphaByte-RedTeam opened this issue Oct 21, 2024 · 2 comments
Open

Comments

@AlphaByte-RedTeam
Copy link

AlphaByte-RedTeam commented Oct 21, 2024

Problem
When executing a query to call a stored procedure, I receive an error indicating that the procedure either doesn't exist or access is denied.

What I try:
I ran the same query with identical parameters and connection settings in DBeaver, and it executed successfully, returning the correct results without any errors.

System I use:

  • Windows 10 Pro 22H2 - x64bit
  • VSCode 1.94.2
  • Vertica driver extension
  • SQL Tools extension latest version

Another context:
image
Screenshot

@sitingren
Copy link
Member

That error message comes from the vertica server. I don't think DBeaver and SQL Tools extension can give different results if all the settings and procedure are identical.

@AlphaByte-RedTeam
Copy link
Author

Anything but calling the SP works just fine. I don't know what is causing the issue, and now I'm using Data Grip as my editor.

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