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

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 Received on Tue Jan 14 2003 - 01:27:36 CST