Re: PLS-201 Identifier <> must be declared when executing from external program

odd.morten.sveas_at_accenture.com (=?ISO-8859-1?Q?Odd_Morten_Sve=E5s?=) wrote in message news:<4306a83.0301132327.71a95fd5_at_posting.google.com>...
> Hi all
> We have a problem that I can figure out:
>
> On our 8.1.7 we have a package AV002_AVREG with a procedure
> AV202_COMP. If we log on with sql*plus or Toad, connecting to user
> whitch owns the pakcage, we can do the following:
>
> begin
> AV002_AVREG.AV202_COMP;
> end;
> /
>
> And it all works fine.
>
> We use an EAI tool, AMTrix, here and from the MessageBuilder code we
> can do a DATABASE EXECUTE and parse in a string containing sql
> commands.
>
> So if we do the following:
> DATABASE EXECUTE("BEGIN AV002_AVREG.AV202_COMP; end;") we get this
> error:
>
> DATABASE EXECUTE: error when executing string: ORA-06550: line 1,
> column 7: PLS-00201: identifier AV002_AVREG.AV202_COMP' must be
> declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
>
> We of course logs in with the same user and evry thing.
>
> In addition I can mention that this works well in our test enviroment
> so clearly there has to be somthing with the database/user/schema or
> ...
>
> The question will be 2 parted:
>
> 1. Does enyone know why this happens?
>
> 2. Is there a table or view that that shows all privelegies so i can
> compair our production- and test enviroment.
>
> Regards
> Odd M

I do not use Toad so I do not know about your first question but for the second you might try querying sys.dba_tab_privs

Also try cooperative FAQ article:
How do I find out which users have the rights, or privileges, to access a given object ?
http://www.jlcomp.demon.co.uk/faq/privileges.html

HTH -- Mark D Powell -- Received on Tue Jan 14 2003 - 08:44:33 CST