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
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
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