Home » RDBMS Server » Server Administration » Problem calling package from pl/sql program
Problem calling package from pl/sql program [message #370371] Wed, 08 September 1999 12:29 Go to next message
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
Re: Problem calling package from pl/sql program [message #370377 is a reply to message #370371] Mon, 13 September 1999 08:06 Go to previous message
Marc
Messages: 26
Registered: August 1999
Junior Member
You can use a public synonym here :

CREATE PUBLIC SYNONYM SynonymName OwnerName.PackageName

After this there is no need anymore to give the Ownername. The package will be know by all the users.
Previous Topic: use of rpad
Next Topic: simple query
Goto Forum:
  


Current Time: Thu Oct 22 04:03:57 CDT 2020