SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Access the table of other user

761447Jul 27 2010 — edited Jul 28 2010

Hi All,
I have two different users as user1 and user2. I have a stored procedure in user2. I want to use the table of user1 in that stored procedure. So I mentioned the table name as user1.TableName in the stored procedure. But it returns the following error,

Error(22,24): PL/SQL: ORA-00942: table or view does not exist

Is it possible to use the different user's table in the stored procedure of another user? If it is possible please help me with the correct syntax.
Thanks,
Ram.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2010

Added on Jul 27 2010

6 comments

4,524 views