Oracle 12i/19, SQuirrelSQL 4.1
I think result of tab Objects > Source for user defined function is broken.
When I want to see source of user defined function, I get blank lines. In last log entry is
privateShowMessage: Exception was: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
and Stack trace contain
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369)
at net.sourceforge.squirrel_sql.plugins.oracle.tab.ObjectSourceTab.getSourceCode(ObjectSourceTab.java:76)
... 44 more
Caused by: Error : 942, Position : 21, Sql = select text from sys.dba_source where type = 'FUNCTION' and owner = '*******' and name = '*****' order by line, OriginalSql = select text from sys.dba_source where type = 'FUNCTION' and owner = '******' and name = '******' order by line, Error Msg = ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
... 57 more
This is because table sys.dba_source doesn't exist for my account. Source is viewable from table sys.all_source. Above applies to (user defined) function, source for table or view is OK.
Is it possible to change in Oracle plugin?
Fixed in our GIT repository. Will be available in future snapshots and versions.
Just to note; This bug is related to but not the same as bug #172.