Menu

#1456 Broken view source for Oracle user defined functions

SQuirreL
closed-fixed
nobody
None
medium
2021-01-11
2021-01-04
jarda_u
No

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?

Discussion

  • Gerd Wagner

    Gerd Wagner - 2021-01-11
    • status: open --> closed-fixed
     
  • Gerd Wagner

    Gerd Wagner - 2021-01-11

    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.

     

Log in to post a comment.

Auth0 Logo