Can someone help:
Using Oracle7...
I have one schema, GENERAL, and have a package P. I grant execute
privilege on P to PUBLIC. Another user tries to declare a variable with
a type declaration contained in package P, but SQLPLUS says that
P.whatevertype must be defined. It only works if the user declares the
variable as type GENERAL.P.whatevertype. Why does the user need to
explicitly name the schema? I have another package with the same type
of setup and users do not need to explicitly state the schema name...
Received on Wed Mar 19 1997 - 00:00:00 CET