Home » SQL & PL/SQL » SQL & PL/SQL » Calling table from another schema inside the procedure
Calling table from another schema inside the procedure [message #9856] Tue, 09 December 2003 09:25 Go to next message
priya
Messages: 108
Registered: February 2000
Senior Member
Hi,
I have a stored procedure inside schema a and I am selecting table data from another schema b. while compiling the stored procedure it gives me an error that b.table is declared. But If I write separate sql statement in sql window like select * from b.table then it returns all rows. Any ideas please?.
thanks in advance
Priya
Re: Calling table from another schema inside the procedure [message #9862 is a reply to message #9856] Tue, 09 December 2003 11:45 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
grant the select priv to user explicitly and NOT THROUGH any ROLE.
and
also try using authid in create procedure syntax
create or replace procedure myProcedure
authid current_user
as

Previous Topic: Does anybody know a tool to show sql code graphically?
Next Topic: Any PL/SQL function or code that does.....
Goto Forum:
  


Current Time: Thu Mar 28 16:05:44 CDT 2024