From: fbortel@home.nl   
      
   DA Singh wrote:   
      
   > Hi,   
   > I have a stored procedure that tries to select from a table owned by   
   > another schema -   
   > create or replace procedure schema1.procedure1   
   > as   
   > insert into table2   
   > select col1, col2   
   > from schema2.table1;   
   > end;   
   > /   
   >   
   > And I get the Ora-942 error - Table or view does not exist.   
   > I can select from the table from the SQL prompt, when logged in as   
   > schema1.   
   > Are there some permissions that need to be set?   
   > The Oracle version is 9.2.0.3.0   
   > Thanks,   
   > D A Singh   
   As always - grant select on table1 to    
   roles are _not_ active in PL/SQL, they are in SQL.   
      
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)