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.

Sign up for GitHub

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

Jump to bottom

[Feature Request]: Improve the way we get the list of DB procedures for oracle #3202

Closed
hansva opened this issue Sep 1, 2023 · 0 comments · Fixed by #3204
Closed

[Feature Request]: Improve the way we get the list of DB procedures for oracle #3202

hansva opened this issue Sep 1, 2023 · 0 comments · Fixed by #3204
Assignees
@nadment
Labels
Database new feature P3 Nice to have Transforms
Milestone
2.6

Comments

@hansva
Copy link
Contributor

hansva commented Sep 1, 2023

What would you like to happen?

The query that is being used to fetch the list of available DB procedures for Oracle is outdated.
Currently we use SELECT DISTINCT DECODE(package_name, NULL, '', package_name||'.') || object_name FROM user_arguments ORDER BY 1
But this only fetches procedures/functions owned by the current user and only those with arguments.

Issue Priority

Priority: 3

Issue Component

Component: Database, Component: Transforms
@nadment nadment self-assigned this Sep 3, 2023
nadment added a commit to nadment/hop that referenced this issue Sep 5, 2023
@nadment
Improve the way we get the list of DB procedures for oracle apache#3202
0333a24
nadment added a commit to nadment/hop that referenced this issue Sep 5, 2023
@nadment
Improve the way we get the list of DB procedures for oracle apache#3202
b2b1c68
@nadment nadment linked a pull request Sep 5, 2023 that will close this issue
Improve the way we get the list of DB procedures for oracle #3202 #3204
Merged
@hansva hansva added this to the 2.6 milestone Sep 5, 2023
hansva added a commit that referenced this issue Sep 5, 2023
@hansva
Merge pull request #3204 from nadment/3202
018a3af 
Improve the way we get the list of DB procedures for oracle #3202
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@nadment nadment

Labels
Database new feature P3 Nice to have Transforms
Projects
None yet
Milestone
2.6
Development

Successfully merging a pull request may close this issue.

Improve the way we get the list of DB procedures for oracle #3202 nadment/hop
2 participants
@hansva @nadment