problem when trying to get to source code from context menu

Null

Member
1.
I am having problem when trying to look at source code for the program units (functions, procedures, packages) using context menu(right mouse click). The message I get is "ora-942 table or view does not exists"
I am trying to look at packages that belong to the user , not sys, nor system.Program units do belong to the user schema, they are not wrap-up.
Select statement that pull source code(text) from user_source works in sql+ perfectly.
2.
Similar problem with table:
when I do desc
from command window I
get error applet with first line "ora-6550 line 43
.... ora-942 ..."
'desc' statement works Ok in sql+
tables do belong to the other schema, they get accessed thru synonyms

DB: ORA9.2
PL/SQL DEV: 5.1.3.704
winXp
 
Can you go to Tools > Preferences > Options tab page, and verify if "Use DBA Views if available" is enabled. If so, disable it and try again.
 
Originally posted by Marco Kalter:
Can you go to Tools > Preferences > Options tab page, and verify if "Use DBA Views if available" is enabled. If so, disable it and try again.
I guess, you guys proved again: your product is GOOD!
It sure did the trick!Once I disabled DBA views everything became visible!
 
Back
Top