SQL error: ORA-04063: package body "WUN.CITYDB_IDX" 有错误 about 3dcitydb HOT 5 CLOSED

Hello,
it seems that your 3DCityDB instance has not been set up correctly, that is, the 3DCityDB package "CITYDB_INX" is missing. Have you received any error messages when you ran the CREATE_DB script via the command line interface?

from 3dcitydb.

Closing, since no feedback has been received. Feel free to re-open if your problem persists.

from 3dcitydb.

Hi there,

I have the same problem as Wun. I didn't receive any error massage during compiling. Actually the cmd-window tells me that all the packages have been created without errors.

What can I do?

Greetings, Johannes

from 3dcitydb.

I don't know if this is related, but I found out that if you are using a role that has only inherited the CREATE INDEX privilege from another role you are not able to execute the DDL commands within the IDX package. The privilege has to be explicitly assigned to the user.

Another option is to add an AUTHID to the IDX package which I did with 3f9a1b1 inside the dev branch.

Simply add AUTHID CURRENT_USER to the package creation command like:

CREATE OR REPLACE PACKAGE citydb_idx AUTHID CURRENT_USER
...

Hopefully, this solves your issues. The new code will be merged into the master soon. I would close the issue then in case I do not receive more error reports.

from 3dcitydb.

Merged to master.

from 3dcitydb.