Weird thing (access not granted to a table from a procedure)

Hi,

I have just created a procedure in a package with the system right.

From the system account, i can run sql commands like select * from username.tablename.

But, the procedure body is not compiled 'cause it pretends username.tablename should be declared first (and when i copy and paste the select statement, it runs perfectly, on the same account).

Thx in advance

Antoine Received on Sun Jun 23 2002 - 08:53:59 CDT