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

Avoid EDITIONABLE keyword on package definition extraction #55

Open
mbrembilla opened this issue Sep 1, 2020 · 1 comment
Open

Avoid EDITIONABLE keyword on package definition extraction #55

mbrembilla opened this issue Sep 1, 2020 · 1 comment
Assignees

Comments

@mbrembilla
Copy link

Hi all,
I found a little issue that annoys me.
When I extract the definition of packages from the db, I always get the keyword EDITIONABLE:
CREATE OR REPLACE EDITIONABLE PACKAGE xx.yy IS ...

Since the code has been written long time ago, before the keyword EDITIONABLE was introduced, this word it's never present in the package definitions and I was expecting the extracted code to be the same.

Is there a way to avoid this behaviour in order to match exactly the db's code? Maybe a configuration somewhere?
The default value when nothing is specified is EDITIONABLE, so it shouldn't change anything.

Regards

Mauro

@qwazer qwazer self-assigned this Sep 1, 2020
@maxxis4
Copy link

maxxis4 commented Jul 26, 2021

@qwazer I try to solve it with this answer:
Stackoverflow

I added version to get_ddl:

public String findPrimaryDDL(final String type, final String name) {
        if (isLaunchedByDBA) 
            return executeDbmsMetadataGetDdl("select dbms_metadata.get_ddl(?, ?, ?, version => '11.2') from dual", type, name, schemaName);
        else
            return executeDbmsMetadataGetDdl("select dbms_metadata.get_ddl(?, ?, version => '11.2') from dual", type, name, null);
    }

and it worked. Maybe with some variable in pom.xml it can be fixed fast without any problems.

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

3 participants