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

PL/SQL Cop for SQLDev doesn't know PRAGMA UDF #3

Closed
DominiqueComte opened this issue Aug 27, 2019 · 2 comments
Closed

PL/SQL Cop for SQLDev doesn't know PRAGMA UDF #3

DominiqueComte opened this issue Aug 27, 2019 · 2 comments
Labels
bug Something isn't working parser

Comments

@DominiqueComte
Copy link

DominiqueComte commented Aug 27, 2019

Hi,

with the version 2.2.0 of PL/SQL Cop, any "PRAGMA UDF;" in a package causes this error :
Blocker
E-0002: Syntax error. Please contact the author if the code compiles successfully in your environment.
no viable alternative at input 'UDF'

an example function definition is :
FUNCTION get_something(p_type VARCHAR2) return VARCHAR2 IS
PRAGMA UDF;
l_product_class VARCHAR2(10);
BEGIN
....

@PhilippSalvisberg
Copy link
Collaborator

Thanks for reporting this issue.

It's a bug of our parser. I've opened a corresponding issue in our private ticketing system. Should be fixed in the next release.

@PhilippSalvisberg PhilippSalvisberg added bug Something isn't working parser labels Aug 28, 2019
@PhilippSalvisberg
Copy link
Collaborator

Fixed. Will be part of next release.

PhilippSalvisberg pushed a commit that referenced this issue Feb 20, 2020
* Added a new test for the property-file functionality
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working parser
Projects
None yet
Development

No branches or pull requests

2 participants