Re: Package problem

"buky" <_buky_zg_at_hotmail.com> wrote in message news:bf8c1t$sm7$1_at_sunce.iskon.hr...
> I have two schemas on one database.
> In 1st schema, I created a package and granted execute to 2nd schema.
> In 2nd schema, inside one package, I call a procedure from granted
 package,
> but I got an error message:
> PLS-00201: identifier 'SUPO_SUCELJE.GLUPA_PROC' must be declared
>
> All arguments and grants are ok, but I still don't know where's problem
>

Possibly the procedure you wish is not a public procedure in schema 1. If it's private then you won;t see it.

Also, maybe the packages have not been created with invoker privalege. Maybe the package in 2nd schema is owner privalige and that owner has not been granted execute on the package in the first schema. Received on Fri Jul 18 2003 - 12:11:30 CEST