Can't see function/procedure/package source codes in plsql/developer

[kayaz]

Hi;
i can't see the function/procedure/package source codes in plsql developer (when i try to view the object source codes, i get "ora-00942 table or view does not exist" error and get error message like /* Source of PACKAGE PKG_TEMP_PACKAGE is not available */ ).
win7 64bit pc, oracle_client 64bit,
notes:
.Tools->Options->"Use DBA Views if available" is checked.
.i can't see the source codes of even my own created objects(functions, procedures etc.). But i can call the functions/procedures in plsql developer.
.i can successfully view and edit/compile the source codes in Toad IDE. (on then same user/db)

Thanks for your help.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the ORA-00942 problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[kayaz]

Hi again;
When i search in the "debug.txt" file, i can see error lines like:
"00:00:02.625 TOracleQuery $0AC30470 Start Query.Describe
SQL = select * from sys.dba_source where rownum < 1
00:00:02.635 TOracleQuery $0AC30470 End
Result = ORA-00942: Table or view does not exist
Duration = 0"

After granting select on "sys.dba_source", "sys.dba_views", "sys.dba_users", "sys.dba_objects" I could successfully see and edit/compile the source codes of functions/procedures/package spec/package body codes. That solves the problem.

Thank you very much for your support.