PL/SQL-Problem with access to table of another user

Hello!

This is my problem:
One pl/sql-Function opens a sql-query with a cursor. In this sql-statment an second pl/sql-Function is called. This second pl/sql-Function again opens a sql-query with a cursor. This sql-statment looks like this:
select name from other_user.table_name;
The following error occurs:

ORA-00942: table or view does not exist
ORA-06512: at "IDAP.PDM", line 341
ORA-06512: at line 1
ORA-06512: at "IDAP.IDAP", line 354
ORA-06512: at line 1

The table exists and access to this table is granted. if i change the query to :
select name from table_name
it works.

If i call the second pl/sql-Function directly, it works, too. If the first pl/sql-Function calls the second without sql-statment it also works.

As anyone a idea, where the error really is?

Thanks for your help,

Ralf

--
Ralf Hofmann
Rosenstr. 3a
85778 Haimhausen
mobile: 0175-2719574
hofmannb_at_informatik.uni-muenchen.de