I am facing an issue with showing errors when compiling packages in sqldeveloper.
Despite having obvious errors in a package, sqldeveloper will return that the package was compiled successfully. Additionally, no messages are entered into the "Messages - Log" view "messages" tab.
After enabling debug (by adding "IncludeConfFile sqldeveloper-debug.conf" to sqldeveloper\bin\sqldeveloper.conf) I was able to get a bit more information about this.
In sqldeveloper 17.3.1.279 build 279.5037, when issuing the show error command, the following shows up in the statements log.
| STATEMENTS LOG |
|---|
| SEQUENCE | CONNECTIONNAME | ELAPSED | SQL | PARAMETERS |
| 37 | connectionname | 2 | select count(1) cnt from all_errors where owner = SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA') | null |
| 36 | connectionname | 3 | select count(1) cnt from user_errors | null |
Looking at ALL_ERRORS, the errors for the package compile in question are under a different owner than my current user. This is causing sqldeveloper to return "package compiled."
In versions prior to 17.3.0 (I am testing with 17.2.0.188 build 188.1159), it appears a list of parameters is used when issuing "show errors."
| STATEMENTS LOG |
|---|
| SEQUENCE | CONNECTION NAME | ELAPSED | SQL | PARAMETERS |
| 42 | connectionname | 2 | select count(1) cnt from all_errors where owner = SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA') | null |
| 41 | connectionname | 3 | SELECT LINE, POSITION, REPLACE(TEXT, CHR(10), ' '), attribute FROM SYS.ALL_ERRORS A WHERE A.NAME = :NAME AND A.TYPE = :TYPE AND A.OWNER = :OWNER ORDER BY ATTRIBUTE, LINE, POSITION -- errors first | "OWNER"="BATCH", "TYPE"="PACKAGE BODY", "NAME"="WSGK_CURRIC_WF" |
| 39 | connectionname | 2 | select count(1) cnt from all_errors where owner = SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA') | null |
| 38 | connectionname | 3 | SELECT LINE, POSITION, REPLACE(TEXT, CHR(10), ' '), attribute FROM SYS.ALL_ERRORS A WHERE A.NAME = :NAME AND A.TYPE = :TYPE AND A.OWNER = :OWNER ORDER BY ATTRIBUTE, LINE, POSITION -- errors first | "OWNER"="BATCH", "TYPE"="PACKAGE", "NAME"="WSGK_CURRIC_WF" |
Since our institution compiles packages under a standard user that is not the current session user, this is a problem. Is there some sort of setting or conf file I can edit to restore this functionality to 17.3.1?