Problem calling package from pl/sql program [message #370371] |
Wed, 08 September 1999 12:29 |
Don Higins
Messages: 1 Registered: September 1999
|
Junior Member |
|
|
My problem is that in a PL/SQL program we are calling
a package created by schema1 by passing it a variable
&1..mypackage.myprocedure
&1 represents the package owner name schema1.
The problem is that this particular program will be
run by many different users including the owner and
when the owner puts in &1 as the schema name it comes
back with an error PLS-00905: object schema1.schema1 is invalid. Oracle seems to take the replacement just fine when any other user other than the package owner
is signed on.
Any ideas
Thanks for your help
|
|
|
|