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

Oracle: Running multiple ALTER PACKAGE XXX COMPILE; commands results in "ORA-00933: SQL command not properly ended" #23452

Open
arglampedakis opened this issue Apr 17, 2024 · 1 comment
Labels
bug x:oracle xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc. xf:sql execution Queries execution xf:sql parser Syntax analyzer xp:normal

Comments

@arglampedakis
Copy link

Description

When running multiple "ALTER PACKAGE XXXX COMPILE;" commands , either by using ctrl+enter, or with alt+x , results in "ORA-00933: SQL command not properly ended"

SQL Processing delimiter settings
image

Also tried with "Statements delimiter: ;" but got the same error.

Attaching gif for better explanation:
dbeaver_multiple_alters_issue

DBeaver Version

Community Edition Version 24.0.2.202404071654

Operating System

Windows 10 Enterprise Version 21H2

Database and driver

Default oracle.jdbc.OracleDriver
image

Steps to reproduce

No response

Additional context

No response

@E1izabeth
Copy link
Member

Thank you for bug report.

@E1izabeth E1izabeth added xp:normal xf:sql execution Queries execution xf:sql parser Syntax analyzer xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc. and removed wait for review labels Apr 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug x:oracle xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc. xf:sql execution Queries execution xf:sql parser Syntax analyzer xp:normal
Projects
None yet
Development

No branches or pull requests

2 participants